Skip navigation links
oracle.javatools.db.sql
Class JoinObject
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.JoinObject
- All Implemented Interfaces:
- ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet
-
public class JoinObject
- extends AbstractSQLFragment
Object that represent the JOIN clause of a SELECT statement (part of the FROM clause).
Field Summary |
static java.lang.String |
CROSS
Inner join type Usage: table_reference CROSS [INNER] JOIN table_reference |
static java.lang.String |
FULL
Outer join type: FULL Usage: table_reference [NATURAL] FULL [OUTER] JOIN table_reference [ON|USING...] |
static java.lang.String |
INNER
Inner join type Usage: table_reference [CROSS|NATURAL] [INNER] JOIN table_reference [ON|USING...] |
static java.lang.String |
LEFT
Outer join type: LEFT Usage: table_reference [NATURAL] LEFT [OUTER] JOIN table_reference [ON|USING...] |
static java.lang.String |
RIGHT
Outer join type: RIGHT Usage: table_reference [NATURAL] RIGHT [OUTER] JOIN table_reference [ON|USING...] |
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, replaceReferenceIDs, setID, setName |
LEFT
public static final java.lang.String LEFT
- Outer join type: LEFT Usage: table_reference [NATURAL] LEFT [OUTER] JOIN table_reference [ON|USING...]
- See Also:
- Constant Field Values
RIGHT
public static final java.lang.String RIGHT
- Outer join type: RIGHT Usage: table_reference [NATURAL] RIGHT [OUTER] JOIN table_reference [ON|USING...]
- See Also:
- Constant Field Values
FULL
public static final java.lang.String FULL
- Outer join type: FULL Usage: table_reference [NATURAL] FULL [OUTER] JOIN table_reference [ON|USING...]
- See Also:
- Constant Field Values
INNER
public static final java.lang.String INNER
- Inner join type Usage: table_reference [CROSS|NATURAL] [INNER] JOIN table_reference [ON|USING...]
- See Also:
- Constant Field Values
CROSS
public static final java.lang.String CROSS
- Inner join type Usage: table_reference CROSS [INNER] JOIN table_reference
- See Also:
- Constant Field Values
JoinObject
public JoinObject()
JoinObject
public JoinObject(FromObject left,
FromObject right,
JoinCondition condition)
- Creates a default join for the given FromObjects and condition. (INNER) Note: If using existing FromObjects for the left or right parameters, it is the responsibility of the API user to remove these FromObjects from the query. Otherwise they will exist in two places: at the top-level and in the JoinObject.
- Parameters:
left
-
right
-
condition
-
JoinObject
public JoinObject(FromObject left,
FromObject right,
java.lang.String type,
boolean natural,
JoinCondition condition)
- Note: If using existing FromObjects for the left or right parameters, it is the responsibility of the API user to remove these FromObjects from the query. Otherwise they will exist in two places: at the top-level and in the JoinObject.
- Parameters:
left
-
right
-
type
-
natural
-
condition
-
getLeftExpression
public FromObject getLeftExpression()
setLeftExpression
public void setLeftExpression(FromObject left)
getRightExpression
public FromObject getRightExpression()
setRightExpression
public void setRightExpression(FromObject right)
getIncludeJoinKeyword
public boolean getIncludeJoinKeyword()
setIncludeJoinKeyword
public void setIncludeJoinKeyword(boolean inc)
getJoinType
public java.lang.String getJoinType()
setJoinType
public void setJoinType(java.lang.String type)
isNatural
public boolean isNatural()
setNatural
public void setNatural(boolean natural)
getCondition
public JoinCondition getCondition()
setCondition
public void setCondition(JoinCondition condition)
getLeftPartitionBy
public ExpressionList getLeftPartitionBy()
setLeftPartitionBy
public void setLeftPartitionBy(ExpressionList leftPartitionBy)
getRightPartitionBy
public ExpressionList getRightPartitionBy()
setRightPartitionBy
public void setRightPartitionBy(ExpressionList rightPartitionBy)
isOuterJoin
public boolean isOuterJoin()
- Returns true if this is a FULL, LEFT or RIGHT OUTER JOIN, and false if this is an INNER JOIN.
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.
-
- Returns:
- a string representing the SQL text for this object.
Skip navigation links
Copyright © 1997, 2011, Oracle. All rights reserved.