|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.6.0) E13403-07 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.javatools.db.AbstractDBObject oracle.javatools.db.AbstractChildDBObject oracle.javatools.db.sql.AbstractSQLFragment oracle.javatools.db.sql.JoinObject
public class JoinObject
Object that represent the JOIN clause of a SELECT statement (part of the FROM clause).
Nested Class Summary |
---|
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport |
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...] |
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, NOCYCLE, ORDERBY, SELECT, STARTWITH, TYPE, WHERE |
Fields inherited from interface oracle.javatools.db.DBObject |
---|
COMMENT |
Constructor Summary | |
---|---|
JoinObject()
|
|
JoinObject(FromObject left,
FromObject right,
JoinCondition condition)
Creates a default join for the given FromObjects and condition. |
|
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. |
Method Summary | |
---|---|
JoinCondition |
getCondition()
|
boolean |
getIncludeJoinKeyword()
|
java.lang.String |
getJoinType()
|
FromObject |
getLeftExpression()
|
ExpressionList |
getLeftPartitionBy()
|
FromObject |
getRightExpression()
|
ExpressionList |
getRightPartitionBy()
|
java.lang.String |
getSQLText()
Return the SQL for this fragment. |
boolean |
isNatural()
|
boolean |
isOuterJoin()
Returns true if this is a FULL, LEFT or RIGHT OUTER JOIN, and false if this is an INNER JOIN. |
void |
setCondition(JoinCondition condition)
|
void |
setIncludeJoinKeyword(boolean inc)
|
void |
setJoinType(java.lang.String type)
|
void |
setLeftExpression(FromObject left)
|
void |
setLeftPartitionBy(ExpressionList leftPartitionBy)
|
void |
setNatural(boolean natural)
|
void |
setRightExpression(FromObject right)
|
void |
setRightPartitionBy(ExpressionList rightPartitionBy)
|
Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment |
---|
appendToBuffer, argsToString, getTextOrNull, getTextOrNull, getType, setParent, 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.ChildDBObject |
---|
getParent |
Methods inherited from interface oracle.javatools.db.DBObject |
---|
copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getReferenceIDs, replaceReferenceIDs, setID, setName |
Methods inherited from interface oracle.javatools.util.DynamicPropertySet |
---|
getProperties, getProperty, getProperty, setProperties, setProperty |
Field Detail |
---|
public static final java.lang.String LEFT
public static final java.lang.String RIGHT
public static final java.lang.String FULL
public static final java.lang.String INNER
public static final java.lang.String CROSS
Constructor Detail |
---|
public JoinObject()
public JoinObject(FromObject left, FromObject right, JoinCondition condition)
left
- right
- condition
- public JoinObject(FromObject left, FromObject right, java.lang.String type, boolean natural, JoinCondition condition)
left
- right
- type
- natural
- condition
- Method Detail |
---|
public FromObject getLeftExpression()
public void setLeftExpression(FromObject left)
public FromObject getRightExpression()
public void setRightExpression(FromObject right)
public boolean getIncludeJoinKeyword()
public void setIncludeJoinKeyword(boolean inc)
public java.lang.String getJoinType()
public void setJoinType(java.lang.String type)
public boolean isNatural()
public void setNatural(boolean natural)
public JoinCondition getCondition()
public void setCondition(JoinCondition condition)
public ExpressionList getLeftPartitionBy()
public void setLeftPartitionBy(ExpressionList leftPartitionBy)
public ExpressionList getRightPartitionBy()
public void setRightPartitionBy(ExpressionList rightPartitionBy)
public boolean isOuterJoin()
public java.lang.String getSQLText()
SQLFragment
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.6.0) E13403-07 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |