如weblogic提供了WebLogic-QL Extensions:
• ORDERBY for sorting on the database side when this feature is available, which is
faster than sorting on the client side.
• GROUP BY for grouping results on the database side when this feature is
available, which is faster than grouping on the client side
• Sub-queries, for example SELECT… WHERE x > (SELECT …).
• Multi-column ejbSelect queries, for example SELECT field1, field2 …,
with the result being returned as a java.sql.ResultSet.
• Many numeric aggregate functions:
• MIN(field)
• MAX(field)
• AVG(field) and AVG(DISTINCT field)
• SUM(field) and SUM(DISTINCT field)
• COUNT(field) and COUNT(DISTINCT field)