Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK
11g Release 2 (11.1.2.2.0)

E17493-03


oracle.javatools.db.ora
Class OracleSQLQuery

java.lang.Object
  extended by oracle.javatools.db.AbstractDBObject
      extended by oracle.javatools.db.AbstractChildDBObject
          extended by oracle.javatools.db.sql.AbstractSQLFragment
              extended by oracle.javatools.db.sql.AbstractSQLQuery
                  extended by 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, AbstractDBObject.ListenerSupport

 

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
CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, 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)
           
protected  void appendSelectSQL(java.lang.StringBuilder sql)
           
 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, clearQueryString, findOwnedObject, getDistinctSource, getFromObjects, getGroupByObject, getHierarchicalQueryObject, getModelObject, getOrderByObjects, getQueryString, getSelectObjects, getSetOperator, getSQLText, getType, getWhereObject, indexOf, indexOf, indexOf, isDistinct, isOrderSiblings, moveFromObject, moveOrderByObject, moveSelectObject, removeFromObject, removeOrderByObject, removeSelectObject, setDistinct, setDistinctSource, setFromObjects, setGroupByObject, setHierarchicalQueryObject, setID, setModelObject, setOrderByObjects, setOrderSiblings, setQueryString, setSelectObjects, setSetOperator, setWhereObject

 

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment
appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, setParent, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

 

Methods inherited from class oracle.javatools.db.AbstractChildDBObject
copyToImpl, findParent, getParent, getProperty, setProperty

 

Methods inherited from class oracle.javatools.db.AbstractDBObject
changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setName, setProperties

 

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, setHierarchicalQueryObject, setOrderByObjects, setSelectObjects, setWhereObject

 

Methods inherited from interface oracle.javatools.db.sql.SQLQuery
getFromObjects, getGroupByObject, getHierarchicalQueryObject, getOrderByObjects, getSelectObjects, getSetOperator, getWhereObject

 

Methods inherited from interface oracle.javatools.db.sql.SQLFragment
getSQLText, getStartOffset

 

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

appendSelectSQL

protected void appendSelectSQL(java.lang.StringBuilder sql)
Overrides:
appendSelectSQL in class AbstractSQLQuery

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

Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK
11g Release 2 (11.1.2.2.0)

E17493-03


Copyright © 1997, 2012, Oracle. All rights reserved.