oracle.javatools.db.sql

Class UsingJoinCondition

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.UsingJoinCondition

All Implemented Interfaces:

ChildDBObject, DBObject, JoinCondition, SQLFragment, Copyable

public class UsingJoinCondition
extends AbstractSQLFragment
implements JoinCondition

Object to represent the condition part of a JOIN that has a USING clause.

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	USING USING keyword - identifies common Column names to JOIN across the tables.

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

Fields inherited from interface oracle.javatools.db.DBObject

COMMENT

Constructor Summary

Constructors

Constructor and Description
UsingJoinCondition()
UsingJoinCondition(FromObjectUsage[] cols)

Method Summary

Modifier and Type	Method and Description
void	addColumn(FromObjectUsage col)
void	addColumn(int index, FromObjectUsage col)
FromObjectUsage[]	getColumns()
java.lang.String	getConditionText() Returns the condition text - this is the sql text without the condition keyword.
java.lang.String	getSQLText() Return the SQL for this fragment.
boolean	removeColumn(FromObjectUsage col)
void	setColumns(FromObjectUsage[] cols)

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

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

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, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, getType, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Field Detail

USING

public static final java.lang.String USING

USING keyword - identifies common Column names to JOIN across the tables.

See Also:

Constant Field Values

Constructor Detail

UsingJoinCondition

public UsingJoinCondition()

UsingJoinCondition

public UsingJoinCondition(FromObjectUsage[] cols)

Method Detail

getColumns

public FromObjectUsage[] getColumns()

setColumns

public void setColumns(FromObjectUsage[] cols)

addColumn

public void addColumn(FromObjectUsage col)

addColumn

public void addColumn(int index,
                      FromObjectUsage col)

removeColumn

public boolean removeColumn(FromObjectUsage col)

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.

Specified by:

getSQLText in interface SQLFragment

Returns:

a string representing the SQL text for this object.

getConditionText

public java.lang.String getConditionText()

Description copied from interface: JoinCondition

Returns the condition text - this is the sql text without the condition keyword.

Specified by:

getConditionText in interface JoinCondition