A named query is a Repository Query or SQL statement that can be invoked by name. With named queries, you can reuse the same query object as often as needed. You can define named queries in an item descriptor; you can also create them in Java code through repository APIs.

Note: Named queries are supported only in SQL and Integration repositories.

Named Queries and Item Inheritance

Item descriptor subtypes inherit the named queries defined for their parent item types. For example, a financial application might define a user item type with investor and broker subtypes. If the user item descriptor defines a named query getUsersByLogin, the investor and broker subtypes also have access to the same named query.

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices