oracle.javatools.db.sql

Class SetOperation

java.lang.Object

oracle.javatools.db.AbstractDBObject

oracle.javatools.db.AbstractBuildableObject

oracle.javatools.db.AbstractChildBuildableObject

oracle.javatools.db.sql.AbstractSQLFragment

oracle.javatools.db.sql.Operation

oracle.javatools.db.sql.SetOperation

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, Copyable, DynamicPropertySet

public class SetOperation
extends Operation

SQLFragment for dealing with operations to do with sets and ranges like IN and BETWEEN.

Nested Class Summary

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

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields

Modifier and Type	Field and Description
static int	BETWEEN
static int	EQUALS_ANY
static int	IN
static int	INTERSECT
static int	MINUS
static int	NOT_BETWEEN
static int	NOT_IN
static int	UNION
static int	UNION_ALL

Fields inherited from class oracle.javatools.db.sql.AbstractSQLFragment

COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, 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

Constructors

Constructor and Description
SetOperation()
SetOperation(int operator, SQLFragment[] args)

Method Summary

Methods

Modifier and Type	Method and Description
int	getOperator()
protected java.lang.String	getOperatorText()
static int	getSetOperation(java.lang.String operation) Returns the set operation for a given string.
static java.lang.String	getSetOperator(int operator)
java.lang.String	getSQLText() Returns the complete SQL representation for this Function fragment.
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, removeArgument, setArguments, setCommutative, setFunctionFormat, setSeparator

Methods inherited from class oracle.javatools.db.sql.AbstractSQLFragment

appendToBuffer, argsToString, getStartOffset, getTextOrNull, getTextOrNull, getType, setStartOffset, surroundWithBrackets, surroundWithBrackets, toString

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

setParent

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

checkInit, checkInit, fireObjectUpdated, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, firePropertyChanged, getChildSupport, getID, getName, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, setID, setName, setProperties, setProperty

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getReferenceIDs, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

getProperty, getProperty, setProperties, setProperty

Field Detail

BETWEEN

public static final int BETWEEN

See Also:

Constant Field Values

NOT_BETWEEN

public static final int NOT_BETWEEN

See Also:

Constant Field Values

IN

public static final int IN

See Also:

Constant Field Values

EQUALS_ANY

public static final int EQUALS_ANY

See Also:

Constant Field Values

NOT_IN

public static final int NOT_IN

See Also:

Constant Field Values

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

SetOperation

public SetOperation()

SetOperation

public SetOperation(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

getSQLText

public java.lang.String getSQLText()

Description copied from class: Operation

Returns the complete SQL representation for this Function fragment.

Specified by:

getSQLText in interface SQLFragment

Overrides:

getSQLText in class Operation

Returns:

a string representing the SQL text for this object.

getSetOperation

public static int getSetOperation(java.lang.String operation)

Returns the set operation for a given string. Returns -1 if the input string is not a set 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)