Home / Middleware / Oracle TopLink

3 Java Persistence Query Language Extensions

Oracle TopLink provides many extensions to the standard JPA Java Persistence Query Language (JPQL). These extensions, referred to as the EclipseLink Query Language (EQL), provide access to additional database features many of which are part of standard SQL, provide access to native database features and functions, and provide access to Oracle TopLink specific features.

This chapter contains the following sections:

• Special Operators

• EclipseLink Query Language

For more information on JQPL, see:

• "Query Language" in the JPA Specification (http://jcp.org/en/jsr/detail?id=317)

• "The Java Persistence Query Language" in The Java EE 6 Tutorial (http://docs.oracle.com/javaee/6/tutorial/doc/bnbtg.html)

3.1 Special Operators

EclipseLink defines the following operators to perform database operations that would not be possible in standard JPQL:

• COLUMN

• FUNCTION

• OPERATOR

• SQL

3.2 EclipseLink Query Language

Oracle TopLink provides access to the following EclipseLink EQL functions:

• CAST

• EXCEPT

• EXTRACT

• INTERSECT

• ON

• REGEXP

• TABLE

• TREAT

• UNION