Java Persistence API (JPA) Extensions Reference for EclipseLink,
Release 2.5 |
|
 |
 |
Use TABLE to access unmapped tables.
Usage
With the TABLE function, you use join, collection, history, auditing, or system tables in a JPQL query.
Examples
Example 3-13 shows how to use an audit table (unmapped) within a SELECT statement.
Example 3-13 Using TABLE EQL
SELECT e, a.LAST_UPDATE_USER FROM Employee e, TABLE('AUDIT') a WHERE a.TABLE = 'EMPLOYEE' AND a.ROWID = COLUMN('ROWID', e)
See Also
For more information, see:
