oracle.javatools.db.ora
Class OracleSQLQuery

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractChildDBObject
          oracle.javatools.db.sql.AbstractSQLFragment
              oracle.javatools.db.sql.AbstractSQLQuery
                  oracle.javatools.db.ora.OracleSQLQuery

All Implemented Interfaces:

ChildDBObject, DBObject, DeclarativeSQLQuery, SQLFragment, SQLQuery, Copyable, DynamicPropertySet

public class OracleSQLQuery
extends AbstractSQLQuery
implements DeclarativeSQLQuery

Object that represents a complete SQL query.

Since:

10.1.3

Nested Class Summary

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport

Field Summary

static java.lang.String

DUAL

Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment

DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE

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

TYPE

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

FROM, GROUPBY, HAVING, ORDERBY, SELECT, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

OracleSQLQuery()
Create a new OracleSQLQuery object.

Method Summary

protected void	appendFromSQL(java.lang.StringBuilder sql)
DBObject	copyTo(DBObject target, DBObject copyParent, IDPolicy idPolicy) Internal copy method used by the API to perform copy operations.
boolean	equals(java.lang.Object obj)
boolean	isDeclarative() Tests whether this query has been fully built declaratively - i.e.

Methods inherited from class oracle.javatools.db.sql.AbstractSQLQuery

addFromObject, addFromObject, addOrderByObject, addOrderByObject, addSelectObject, addSelectObject, appendSelectSQL, clearQueryString, copyToImpl, equalsImpl, findOwnedObject, getDistinctSource, getFromObjects, getGroupByObject, getName, getOrderByObjects, getOwnedObjectsImpl, getQueryString, getSelectObjects, getSQLText, getType, getWhereObject, indexOf, indexOf, indexOf, isDistinct, moveFromObject, moveOrderByObject, moveSelectObject, removeFromObject, removeOrderByObject, removeSelectObject, setDistinct, setDistinctSource, setFromObjects, setGroupByObject, setID, setName, setOrderByObjects, setQueryString, setSelectObjects, setWhereObject

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment

appendToBuffer, argsToString, getTextOrNull, getTextOrNull, setParent, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildDBObject

copyToImpl, findParent, getParent

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyToImpl, equalsImpl, findOwnedObject, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setProperties, setProperty

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

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

addFromObject, addFromObject, addOrderByObject, addOrderByObject, addSelectObject, addSelectObject, indexOf, indexOf, indexOf, moveFromObject, moveOrderByObject, moveSelectObject, removeFromObject, removeOrderByObject, removeSelectObject, setFromObjects, setGroupByObject, setOrderByObjects, setSelectObjects, setWhereObject

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

getFromObjects, getGroupByObject, getOrderByObjects, getSelectObjects, getWhereObject

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

DUAL

public static final java.lang.String DUAL

See Also:

Constant Field Values

Constructor Detail

OracleSQLQuery

public OracleSQLQuery()

Create a new OracleSQLQuery object.

Method Detail

copyTo

public DBObject copyTo(DBObject target,
                       DBObject copyParent,
                       IDPolicy idPolicy)

Description copied from class: AbstractDBObject

Internal copy method used by the API to perform copy operations. All objects must implement this method if they are instantiable objects. Abstract objects (e.g. Relation) must NOT implement this method. The implementation should delegate to the copyToImpl method to copy the actual properties.

This method does not fix internal reference ids on copy. That is done by the calling DBObject.copyTo(DBObject, IDPolicy) method.

Specified by:

copyTo in class AbstractDBObject

See Also:

DBObject.copyTo(java.lang.Object), DBObject.copyTo(DBObject, boolean), AbstractDBObject.copyToImpl(oracle.javatools.db.AbstractDBObject, oracle.javatools.db.DBObject, oracle.javatools.db.IDPolicy)

equals

public boolean equals(java.lang.Object obj)

Overrides:

equals in class java.lang.Object

appendFromSQL

protected void appendFromSQL(java.lang.StringBuilder sql)

Overrides:

appendFromSQL in class AbstractSQLQuery

isDeclarative

public boolean isDeclarative()

Description copied from interface: SQLQuery

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.

Specified by:

isDeclarative in interface SQLQuery