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

Fields inherited from interface oracle.javatools.db.sql.SQLFragment

CONNECTBY, FROM, GROUPBY, HAVING, NOCYCLE, ORDERBY, SELECT, STARTWITH, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Method Summary

FromObject[]	getFromObjects() Get all the from objects for this query.
GroupByObject	getGroupByObject() Gets the "GROUP BY ...
HierarchicalQueryObject	getHierarchicalQueryObject() Get the "CONNECT BY ...
OrderByObject[]	getOrderByObjects() Get all the OrderBy objects for this query.
SelectObject[]	getSelectObjects() Get all the select objects for this query.
WhereObject	getWhereObject() Gets the WHERE clause for this query.
boolean	isDeclarative() Tests whether this query has been fully built declaratively - i.e.

Methods inherited from interface oracle.javatools.db.sql.SQLFragment

getSQLText

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Field Detail

TYPE

static final java.lang.String TYPE

See Also:

Constant Field Values

Method Detail

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.