oracle.javatools.db.sql

Class SetOperator

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

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, SQLFragmentWithDatatype, Copyable

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.

Not to be confused with SetOperation which deals with operators of value sets (e.g. IN, BETWEEN etc).

Since:

11.1.2

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SetOperator.Operator Valid operators for a SetOperator.

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

AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

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

AS, COMMA, DEFAULT_SEPARATOR, EMPTY, EMPTY_ARRAY, INDENT, LEFT_PAREN, NEWLINE, RIGHT_PAREN, 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
SetOperator()
SetOperator(SetOperator.Operator operator, SQLFragment[] args)

Method Summary

Modifier and Type	Method and Description
SetOperator.Operator	getOperator()
protected java.lang.String	getOperatorText()
static SetOperator.Operator	getSetOperator(java.lang.String operator) Converts the sql for an operator in to the appropriate enum value.
void	setOperator(SetOperator.Operator operator)

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

addArgument, addArgument, addArguments, checkArgument, checkNewSize, copyToImpl, equalsImpl, getArgumentCount, getArguments, getDataTypeID, getDistinctText, getSeparator, getSQLText, removeArgument, setArguments, setCommutative, setFunctionFormat, setSeparator

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

appendToBuffer, appendToBuffer, argsToString, getName, 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, getOwnedObjectsImpl, getProperties, getReferenceIDsImpl, needsInitialization, processPropertyChange, setID

Methods inherited from class oracle.javatools.db.AbstractDBObject

addObjectListener, addObjectListener, addObjectListener, changeParent, compareToImpl, copyObject, copyTo, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, findOwnedObject, findParent, fireObjectUpdated, firePropertyChanged, getChildSupport, getChildSupport, getID, getOwnedObjects, getOwnedObjects, getParent, getProperty, getProperty, getReferenceIDs, hashCode, includeOwnedObject, includesType, includesType, removeObjectListener, removeObjectListener, removeObjectListener, removeOwnedObject, removeThisAsParent, replaceReferenceIDs, 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.sql.SQLFragment

getStartOffset

Methods inherited from interface oracle.javatools.db.ChildDBObject

getParent, setParent

Methods inherited from interface oracle.javatools.db.DBObject

addObjectListener, copyTo, copyTo, copyTo, equals, findOwnedObject, findOwnedObject, findOwnedObject, getID, getName, getOwnedObjects, getOwnedObjects, getProperties, getProperty, getProperty, getReferenceIDs, getType, hashCode, removeObjectListener, removeOwnedObject, replaceReferenceIDs, setID, setName, setProperties, setProperty

Constructor Detail

SetOperator

public SetOperator()

SetOperator

public SetOperator(SetOperator.Operator operator,
                   SQLFragment[] args)

Method Detail

setOperator

public void setOperator(SetOperator.Operator operator)

getOperator

public SetOperator.Operator getOperator()

getOperatorText

protected java.lang.String getOperatorText()

Specified by:

getOperatorText in class Operation

getSetOperator

public static SetOperator.Operator getSetOperator(java.lang.String operator)

Converts the sql for an operator in to the appropriate enum value.

Parameters:

operator - the sql to convert

Returns:

null if the sql is not a SetOperator.Operator