oracle.javatools.db.sql
Class FromObject

java.lang.Object
  oracle.javatools.db.AbstractDBObject
      oracle.javatools.db.AbstractChildDBObject
          oracle.javatools.db.sql.AbstractSQLFragment
              oracle.javatools.db.sql.AbstractAliasFragment
                  oracle.javatools.db.sql.FromObject

All Implemented Interfaces:

ChildDBObject, DBObject, AliasFragment, SQLFragment, Copyable, DynamicPropertySet

public class FromObject
extends AbstractAliasFragment

Object that represents a clause in the FROM statement of a 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	AS
static java.lang.String	LEFT_PAREN
static java.lang.String	RIGHT_PAREN
static java.lang.String	TYPE
static java.lang.String	WITH

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, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

FromObject()
Create an empty FROM object.

FromObject(SQLFragment expression, java.lang.String alias)
Create a FROM object with the given expression and alias.

Method Summary

boolean	canHaveAlias() In certain circumstances an AliasFragment cannot have an alias.
SQLFragment	getPivotExpression()
java.lang.String	getSQLText() Returns the entire fragment (expression plus alias in external form).
SQLFragment	getSubqueryFactoringClause()
java.lang.String	getType() Returns the type of this object.
boolean	isWith()
void	setExpression(SQLFragment exp) Sets the expression part of the fragment.
void	setPivotExpression(SQLFragment pivot)
void	setSubqueryFactoringClause(SQLFragment value)
void	setWith(boolean value)

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

canUseAsAlias, getAlias, getExpression, getName, getUsableAlias, setAlias, setName, toString, useAsBeforeAlias

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

appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, setParent, setStartOffset, surroundWithBrackets, surroundWithBrackets

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, getOwnedObjects, getOwnedObjects, getOwnedObjectsImpl, getProperties, getProperty, getReferenceIDs, getReferenceIDsImpl, hashCode, includeOwnedObject, includesType, includesType, removeThisAsParent, replaceReferenceIDs, setID, setProperties

Methods inherited from class java.lang.Object

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

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

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, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID

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

WITH

public static final java.lang.String WITH

See Also:

Constant Field Values

AS

public static final java.lang.String AS

See Also:

Constant Field Values

LEFT_PAREN

public static final java.lang.String LEFT_PAREN

See Also:

Constant Field Values

RIGHT_PAREN

public static final java.lang.String RIGHT_PAREN

See Also:

Constant Field Values

Constructor Detail

FromObject

public FromObject()

Create an empty FROM object.

FromObject

public FromObject(SQLFragment expression,
                  java.lang.String alias)

Create a FROM object with the given expression and alias.

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.

setExpression

public void setExpression(SQLFragment exp)

Description copied from class: AbstractAliasFragment

Sets the expression part of the fragment.

Specified by:

setExpression in interface AliasFragment

Overrides:

setExpression in class AbstractAliasFragment

setPivotExpression

public void setPivotExpression(SQLFragment pivot)

getPivotExpression

public SQLFragment getPivotExpression()

canHaveAlias

public boolean canHaveAlias()

Description copied from class: AbstractAliasFragment

In certain circumstances an AliasFragment cannot have an alias. This method returns false if that is the case.

Overrides:

canHaveAlias in class AbstractAliasFragment

setWith

public void setWith(boolean value)

isWith

public boolean isWith()

setSubqueryFactoringClause

public void setSubqueryFactoringClause(SQLFragment value)

getSubqueryFactoringClause

public SQLFragment getSubqueryFactoringClause()

getSQLText

public java.lang.String getSQLText()

Description copied from class: AbstractAliasFragment

Returns the entire fragment (expression plus alias in external form).

Specified by:

getSQLText in interface AliasFragment

Specified by:

getSQLText in interface SQLFragment

Overrides:

getSQLText in class AbstractAliasFragment

Returns:

a string representing the SQL text for this object.