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

Nested Class Summary

Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

static int	INTERSECT
static int	MINUS
static int	UNION
static int	UNION_ALL

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

SetOperator()

SetOperator(int operator, SQLFragment[] args)

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.AbstractChildDBObject

findParent, getParent, getProperty, setProperty

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.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

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

Constructor Detail

SetOperator

public SetOperator()

SetOperator

public SetOperator(int operator,
                   SQLFragment[] args)

Method Detail

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