oracle.javatools.db.sql

Class SelectObject

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.AbstractAliasFragment

oracle.javatools.db.sql.SelectObject

All Implemented Interfaces:

ChildDBObject, DBObject, AliasFragment, SQLFragment, Copyable

public class SelectObject
extends AbstractAliasFragment

Object that represents a clause in the SELECT 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

Fields

Modifier and Type	Field and Description
static java.lang.String	TYPE

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

AS, COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, LEFT_PAREN, NEWLINE, RIGHT_PAREN, 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

Constructors

Constructor and Description
SelectObject() Create an empty select object.
SelectObject(SQLFragment expression, java.lang.String alias) Create a select object with the given expression and alias.
SelectObject(SQLFragment expression, java.lang.String alias, boolean useAs) Create a select object with the given expression and alias.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getType() Returns the type of this object.
java.lang.String	getUsableAlias() Obtains a String that can be used as an alias to this fragment.
boolean	isUseAs() Gets whether or not this select object will use AS between expression and alias in the sql text.
void	setUseAs(boolean useAs) Sets whether or not this select object should use AS between expression and alias in the sql text.
protected boolean	useAsBeforeAlias() Returns true if the current fragment should have an AS between expression and alias.

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

canHaveAlias, canUseAsAlias, getAlias, getExpression, getName, getSQLText, setAlias, setExpression, toString

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

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

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, copyToImpl, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, equalsImpl, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setName, 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.SQLFragment

getStartOffset

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Field Detail

TYPE

public static final java.lang.String TYPE

See Also:

Constant Field Values

Constructor Detail

SelectObject

public SelectObject()

Create an empty select object.

SelectObject

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

Create a select object with the given expression and alias.

SelectObject

public SelectObject(SQLFragment expression,
                    java.lang.String alias,
                    boolean useAs)

Create a select 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.

useAsBeforeAlias

protected boolean useAsBeforeAlias()

Description copied from class: AbstractAliasFragment

Returns true if the current fragment should have an AS between expression and alias. Returns false by default, subclasses override if appropraite.

Overrides:

useAsBeforeAlias in class AbstractAliasFragment

setUseAs

public void setUseAs(boolean useAs)

Sets whether or not this select object should use AS between expression and alias in the sql text.

isUseAs

public boolean isUseAs()

Gets whether or not this select object will use AS between expression and alias in the sql text.

getUsableAlias

public java.lang.String getUsableAlias()

Description copied from interface: AliasFragment

Obtains a String that can be used as an alias to this fragment. Can return null if there is no alias set, and the expression is not a valid alias. DBObject names are in external form. This is different to getName() because that will always return the expression even if it is not a valid alias.

Specified by:

getUsableAlias in interface AliasFragment

Overrides:

getUsableAlias in class AbstractAliasFragment

Returns:

the alias if there is one, otherwise the expression text if it could be a valid alias.