oracle.javatools.db.sql
Class HierarchicalQueryObject

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractChildDBObject
          oracle.javatools.db.sql.AbstractSQLFragment
              oracle.javatools.db.sql.HierarchicalQueryObject

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet

public class HierarchicalQueryObject
extends AbstractSQLFragment

SQLFragment for the Hierarchical Query clause in a SQLQuery.

CONNECT BY ... START WITH ...

START WITH ... CONNECT BY ...

Nested Class Summary

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

AbstractDBObject.ChildSupport

Field Summary

static java.lang.String

TYPE

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

DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, NEWLINE, SPACE

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

Constructor Summary

HierarchicalQueryObject()

HierarchicalQueryObject(SQLFragment connectBy, SQLFragment startWith, boolean startWithFirst, boolean noCycle)

Method Summary

SQLFragment	getConnectBy()
boolean	getNoCycle()
java.lang.String	getSQLText() Return the SQL for this fragment.
SQLFragment	getStartWith()
boolean	getStartWithFirst()
java.lang.String	getType() Returns the type of this object.
void	setConnectBy(SQLFragment connectBy)
void	setNoCycle(boolean noCycle)
void	setStartWith(SQLFragment startWith)
void	setStartWithFirst(boolean startWithFirst)

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, getProperty, setProperty

Methods inherited from class oracle.javatools.db.AbstractDBObject

changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties

Methods inherited from class java.lang.Object

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

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent

Methods inherited from interface oracle.javatools.db.DBObject

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

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

HierarchicalQueryObject

public HierarchicalQueryObject()

HierarchicalQueryObject

public HierarchicalQueryObject(SQLFragment connectBy,
                               SQLFragment startWith,
                               boolean startWithFirst,
                               boolean noCycle)

Method Detail

getType

public java.lang.String getType()

Description copied from interface: DBObject

Returns the type of this object. Valid types include things like tables, views, synonyms, and columns.

Specified by:

getType in interface DBObject

Overrides:

getType in class AbstractSQLFragment

Returns:

a string describing the type of object.

setConnectBy

public void setConnectBy(SQLFragment connectBy)

getConnectBy

public SQLFragment getConnectBy()

setStartWith

public void setStartWith(SQLFragment startWith)

getStartWith

public SQLFragment getStartWith()

setStartWithFirst

public void setStartWithFirst(boolean startWithFirst)

getStartWithFirst

public boolean getStartWithFirst()

setNoCycle

public void setNoCycle(boolean noCycle)

getNoCycle

public boolean getNoCycle()

getSQLText

public java.lang.String getSQLText()

Description copied from interface: SQLFragment

Return the SQL for this fragment. This contains no validation - if the implementation is incomplete it will just return what it has. Error checking of fragments should be done using a SQLQueryBuilder.

Returns:

a string representing the SQL text for this object.