oracle.javatools.db.sql

Class Comparison

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

All Implemented Interfaces:

ChildDBObject, DBObject, SQLFragment, SQLFragmentWithDatatype, Copyable

public class Comparison
extends Operation

Subclass of Operation for comparisons. Operation only has two arguments - a left and right expression.
By default a Comparison object is EQUAL

Since:

10.1.3

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Comparison.Comparator Valid comparators for SQL.

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
Comparison() Constructs a new, empty, comparison object.
Comparison(Comparison.Comparator comparator, SQLFragment[] argsL) Constructs a new comparison fragment for regexp_like, which has function format.
Comparison(SQLFragment left, Comparison.Comparator comparator) Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS and NOT EXISTS.
Comparison(SQLFragment left, Comparison.Comparator comparator, SQLFragment right) Constructs a new comparison fragment with the given expressions and comparator.

Method Summary

Modifier and Type	Method and Description
void	addArgument(int index, SQLFragment expression)
void	addArgument(SQLFragment expression)
void	addArguments(SQLFragment[] expressions)
protected void	checkNewSize(int proposedSize) Override for operations that have specific size restrictions.
int	getArgumentCount() Returns the number of arguments stored.
SQLFragment[]	getArguments() Returns the arguments stored in this function.
Comparison.Comparator	getComparator() Returns the comparator for this comparison fragment.
static Comparison.Comparator	getComparator(java.lang.String sql)
SQLFragment	getLeftExpression() Gets the left expression.
java.lang.String	getOperatorText() Returns the text for the comparator for this comparison fragment.
boolean	getPriorOnLeft() Has the left expression got a PRIOR operator
boolean	getPriorOnRight() Has the right expression got a PRIOR operator
SQLFragment	getRightExpression() Gets the right expression.
java.lang.String	getSQLText() Returns the complete SQL representation for this Function fragment.
boolean	removeArgument(SQLFragment expression)
void	setArguments(SQLFragment[] arguments) Sets the arguments for this function.
void	setComparator(Comparison.Comparator comparator) Sets the comparator for this comparison object.
void	setLeftExpression(SQLFragment leftExpression) Sets the left expression.
void	setPriorOnLeft(boolean priorOnLeft) Set whether the left expression has a PRIOR operator
void	setPriorOnRight(boolean priorOnRight) Set whether the right expression has a PRIOR operator
void	setRightExpression(SQLFragment rightExpression) Sets the right expression.

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

checkArgument, copyToImpl, equalsImpl, getDataTypeID, getDistinctText, getSeparator, 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

Comparison

public Comparison()

Constructs a new, empty, comparison object.

Comparison

public Comparison(SQLFragment left,
                  Comparison.Comparator comparator)

Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS and NOT EXISTS.

Comparison

public Comparison(Comparison.Comparator comparator,
                  SQLFragment[] argsL)

Constructs a new comparison fragment for regexp_like, which has function format.

Comparison

public Comparison(SQLFragment left,
                  Comparison.Comparator comparator,
                  SQLFragment right)

Constructs a new comparison fragment with the given expressions and comparator.

Method Detail

getComparator

public Comparison.Comparator getComparator()

Returns the comparator for this comparison fragment. Use getComparatorText() to return By default a Comparison object is EQUAL

getOperatorText

public java.lang.String getOperatorText()

Returns the text for the comparator for this comparison fragment. By default a Comparison object is EQUAL

Specified by:

getOperatorText in class Operation

setComparator

public void setComparator(Comparison.Comparator comparator)

Sets the comparator for this comparison object. One of the static members must be used or an IllegalArgumentException will be thrown.

getLeftExpression

public SQLFragment getLeftExpression()

Gets the left expression.

setLeftExpression

public void setLeftExpression(SQLFragment leftExpression)

Sets the left expression.

getRightExpression

public SQLFragment getRightExpression()

Gets the right expression.

setRightExpression

public void setRightExpression(SQLFragment rightExpression)

Sets the right expression.

setPriorOnLeft

public void setPriorOnLeft(boolean priorOnLeft)

Set whether the left expression has a PRIOR operator

getPriorOnLeft

public boolean getPriorOnLeft()

Has the left expression got a PRIOR operator

setPriorOnRight

public void setPriorOnRight(boolean priorOnRight)

Set whether the right expression has a PRIOR operator

getPriorOnRight

public boolean getPriorOnRight()

Has the right expression got a PRIOR operator

checkNewSize

protected void checkNewSize(int proposedSize)

Description copied from class: Operation

Override for operations that have specific size restrictions. Subclasses should throw an IllegalArgumentException if the proposed new size is illegal.

Overrides:

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

addArgument

public void addArgument(int index,
                        SQLFragment expression)

Overrides:

addArgument in class Operation

addArgument

public void addArgument(SQLFragment expression)

Overrides:

addArgument in class Operation

addArguments

public void addArguments(SQLFragment[] expressions)

Overrides:

addArguments in class Operation

getArgumentCount

public int getArgumentCount()

Description copied from class: Operation

Returns the number of arguments stored.

Overrides:

getArgumentCount in class Operation

setArguments

public void setArguments(SQLFragment[] arguments)

Description copied from class: Operation

Sets the arguments for this function.

Overrides:

setArguments in class Operation

removeArgument

public boolean removeArgument(SQLFragment expression)

Overrides:

removeArgument in class Operation

getArguments

public SQLFragment[] getArguments()

Description copied from class: Operation

Returns the arguments stored in this function.

Overrides:

getArguments in class Operation

getComparator

public static Comparison.Comparator getComparator(java.lang.String sql)