Skip navigation links

oracle.javatools.db.sql
Class ColumnUsage

java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.AbstractFromObjectUsage
oracle.javatools.db.sql.AbstractDBObjectUsage
oracle.javatools.db.sql.ColumnUsage

All Implemented Interfaces:

ChildDBObject, DBObject, ProviderUsage, DBObjectUsage, FromObjectUsage, SQLFragment, Copyable, DynamicPropertySet

public class ColumnUsage

extends AbstractDBObjectUsage

SQL fragment that is a use of a Column. Used as a child of SelectObject or WhereObject.

Since:

10.1.3

Nested Class Summary

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

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

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, TYPE, WHERE

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

ColumnUsage()
Create an empty ColumnUsage.

ColumnUsage(DBObjectID colID)
Create a ColumnUsage using the given Column ID to reference.

ColumnUsage(DBObjectID colID, FromObject from)
Create a ColumnUsage using the given Column ID and FromObject to reference.

Method Summary

java.lang.String[]	getAttributes() Gets the list of attributes used.
java.lang.String	getSQLText() Returns the SQLText for the ColumnUsage.
boolean	isOuterJoin() Returns true if this column usage includes the outer join syntax for a where clause.
void	setAlwaysQuote(boolean boo)
void	setAttributes(java.lang.String[] attrs) Sets the list of attributes used (if any).
void	setColumnID(DBObjectID colID) Deprecated.
void	setOuterJoin(boolean oj) Sets whether this column usage contains the where clause syntax for an outer join.

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

copyToImpl, getColumnName, getExternalName, getObjectID, getProvider, setObjectID, setProvider

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

getFromObject, getFromObjectID, getSQLTextImpl, isQualified, resolveFromObject, resolveFromObject, setFromObject, setFromObjectID, setQualified

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

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

Methods inherited from class oracle.javatools.db.AbstractChildDBObject

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.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, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperties, getProperty, getProperty, setProperties, setProperty

Constructor Detail

ColumnUsage

public ColumnUsage()

Create an empty ColumnUsage.

ColumnUsage

public ColumnUsage(DBObjectID colID)

Create a ColumnUsage using the given Column ID to reference.

ColumnUsage

public ColumnUsage(DBObjectID colID,
                   FromObject from)

Create a ColumnUsage using the given Column ID and FromObject to reference.

Method Detail

setColumnID

@Deprecated
public void setColumnID(DBObjectID colID)

Deprecated.

getAttributes

public java.lang.String[] getAttributes()

Gets the list of attributes used. If the Column used has an object type datatype then it is possible to reference an attribute of that object type in the query directly. Furthermore if that attribute has an object type datatype we can recurse. The attribute list is currently returned as a String[] but we may move to a DBObjectID[] in the next release.

setAttributes

public void setAttributes(java.lang.String[] attrs)

Sets the list of attributes used (if any).

See Also:

getAttributes()

setOuterJoin

public void setOuterJoin(boolean oj)

Sets whether this column usage contains the where clause syntax for an outer join.

isOuterJoin

public boolean isOuterJoin()

Returns true if this column usage includes the outer join syntax for a where clause.

getSQLText

public java.lang.String getSQLText()

Returns the SQLText for the ColumnUsage. It uses the alias, or if not present the sql expression, for the FromObject, dot, the Column name.

Returns:

a string representing the SQL text for this object.

setAlwaysQuote

public void setAlwaysQuote(boolean boo)

Skip navigation links