Skip navigation links

oracle.javatools.db.sql
Class UsingJoinCondition

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

All Implemented Interfaces:

ChildDBObject, DBObject, JoinCondition, SQLFragment, Copyable, DynamicPropertySet

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

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

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

UsingJoinCondition()

UsingJoinCondition(FromObjectUsage[] cols)

Method Summary

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, argsToString, getStartOffset, getTextOrNull, getTextOrNull, getType, setParent, setStartOffset, 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.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

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

Skip navigation links