Skip navigation links
oracle.javatools.db.sql
Interface SQLQuery
- All Superinterfaces:
- ChildDBObject, Copyable, DBObject, DynamicPropertySet, SQLFragment
- All Known Subinterfaces:
- DeclarativeSQLQuery
- All Known Implementing Classes:
- AbstractSQLQuery, NonDeclarativeSQLQuery, OracleSQLQuery
-
public interface SQLQuery
- extends SQLFragment
Object that represents a basic SQL query. The getSQLText() method on this interface has no validation. It will return an incomplete or invalid query if the objects making up the SQLQuery are themselves incomplete or invalid.
It is strongly recommended that a SQLQueryBuilder is used to create and edit a SQLQuery. All support for dependent objects, cascade deletes and links to Relations, Columns and FKConstraints is in the SQLQueryBuilder interface. This object is a simple container to encapsulate the query data.
- Since:
- 10.1.3
Field Summary |
static java.lang.String |
TYPE
|
Methods inherited from interface oracle.javatools.db.DBObject |
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName |
TYPE
static final java.lang.String TYPE
-
- See Also:
- Constant Field Values
getSelectObjects
SelectObject[] getSelectObjects()
- Get all the select objects for this query.
getFromObjects
FromObject[] getFromObjects()
- Get all the from objects for this query.
getWhereObject
WhereObject getWhereObject()
- Gets the WHERE clause for this query.
getOrderByObjects
OrderByObject[] getOrderByObjects()
- Get all the OrderBy objects for this query.
getHierarchicalQueryObject
HierarchicalQueryObject getHierarchicalQueryObject()
- Get the "CONNECT BY ... START WITH ..." clause for this query
getGroupByObject
GroupByObject getGroupByObject()
- Gets the "GROUP BY ... HAVING ..." clause for this query.
isDeclarative
boolean isDeclarative()
- Tests whether this query has been fully built declaratively - i.e. calling getSQLText on the entire query will return the correct query String. Views that aren't fully declarative can still be used for dependency information.
Skip navigation links
Copyright © 1997, 2011, Oracle. All rights reserved.