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.
Field Summary |
static java.lang.String |
USING
USING keyword - identifies common Column names to JOIN across the tables. |
Fields inherited from interface oracle.javatools.db.sql.SQLFragment |
CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, TYPE, WHERE |
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.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.DBObject |
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, getType, replaceReferenceIDs, setID, setName |
USING
public static final java.lang.String USING
- USING keyword - identifies common Column names to JOIN across the tables.
- See Also:
- Constant Field Values
UsingJoinCondition
public UsingJoinCondition()
UsingJoinCondition
public UsingJoinCondition(FromObjectUsage[] cols)
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
Copyright © 1997, 2011, Oracle. All rights reserved.