Skip navigation links
oracle.javatools.db.sql
Class SetOperator
java.lang.Object
oracle.javatools.db.AbstractDBObject
oracle.javatools.db.AbstractChildDBObject
oracle.javatools.db.sql.AbstractSQLFragment
oracle.javatools.db.sql.Operation
oracle.javatools.db.sql.SetOperator
- All Implemented Interfaces:
- ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet
-
public class SetOperator
- extends Operation
SQLFragment for dealing with queries that are linked using one of the SET operators INTERSECT, UNION, MINUS and UNION ALL. The fragment consists of two other fragments, one which is a SQLQuery and the other that is either another SQLQuery or another SetOperator
Fields inherited from interface oracle.javatools.db.sql.SQLFragment |
CONNECTBY, FROM, GROUPBY, HAVING, MODEL, NOCYCLE, ORDERBY, ORDERSIBLINGSBY, PRIOR, SELECT, STARTWITH, TYPE, WHERE |
Method Summary |
int |
getOperator()
|
protected java.lang.String |
getOperatorText()
|
static java.lang.String |
getSetOperator(int operator)
|
static boolean |
isSetOperator(int operator)
Returns true if the given operator is a set operator supported by this function (BETWEEN, IN or their negative counterparts). |
void |
setOperator(int operator)
|
Methods inherited from class oracle.javatools.db.sql.Operation |
addArgument, addArgument, addArguments, checkArgument, checkNewSize, copyToImpl, equalsImpl, getArgumentCount, getArguments, getDistinctText, getSeparator, getSQLText, removeArgument, setArguments, setCommutative, setFunctionFormat, setSeparator |
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, 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 |
INTERSECT
public static final int INTERSECT
-
- See Also:
- Constant Field Values
UNION
public static final int UNION
-
- See Also:
- Constant Field Values
MINUS
public static final int MINUS
-
- See Also:
- Constant Field Values
UNION_ALL
public static final int UNION_ALL
-
- See Also:
- Constant Field Values
SetOperator
public SetOperator()
SetOperator
public SetOperator(int operator,
SQLFragment[] args)
setOperator
public void setOperator(int operator)
getOperator
public int getOperator()
getOperatorText
protected java.lang.String getOperatorText()
-
- Specified by:
getOperatorText
in class Operation
isSetOperator
public static boolean isSetOperator(int operator)
- Returns true if the given operator is a set operator supported by this function (BETWEEN, IN or their negative counterparts).
getSetOperator
public static java.lang.String getSetOperator(int operator)
Skip navigation links
Copyright © 1997, 2012, Oracle. All rights reserved.