Comparison (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

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, Copyable, DynamicPropertySet
```
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/interfaces inherited from class oracle.javatools.db.AbstractDBObject
  AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport

Field Summary

Fields
Modifier and Type	Field and Description
`static int`	`EQUAL` Equal
`static int`	`EQUAL_ALL`
`static int`	`EQUAL_ANY`
`static int`	`EQUAL_SOME`
`static int`	`EXISTS` Exists
`static int`	`GREATER` Greater Than
`static int`	`GREATER_EQUAL` Greater Than Or Equal To
`static int`	`GREATER_THAN_ALL`
`static int`	`GREATER_THAN_ANY`
`static int`	`GREATER_THAN_OR_EQUAL_ALL`
`static int`	`GREATER_THAN_OR_EQUAL_ANY`
`static int`	`GREATER_THAN_OR_EQUAL_SOME`
`static int`	`GREATER_THAN_SOME`
`static int`	`INTERSECT`
`static int`	`LESS` Less Than
`static int`	`LESS_EQUAL` Less Than Or Equal To
`static int`	`LESS_THAN_ALL`
`static int`	`LESS_THAN_ANY`
`static int`	`LESS_THAN_OR_EQUAL_ALL`
`static int`	`LESS_THAN_OR_EQUAL_ANY`
`static int`	`LESS_THAN_OR_EQUAL_SOME`
`static int`	`LESS_THAN_SOME`
`static int`	`LIKE` Like
`static int`	`MINUS`
`static int`	`NOT_EQUAL` Not Equal
`static int`	`NOT_EQUAL_ALL`
`static int`	`NOT_EQUAL_ANY`
`static int`	`NOT_EQUAL_SOME`
`static int`	`NOT_EXISTS` Not Exists
`static int`	`NOT_IN`
`static int`	`NOT_LIKE` Not Like
`static int`	`NOT_NULL` Is Not Null
`static int`	`NULL` Is Null
`static int`	`REGEXP_LIKE` regexp_like
`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
`Comparison()` Constructs a new, empty, comparison object.
`Comparison(int comparator, SQLFragment[] argsL)` Constructs a new comparison fragment for regexp_like, which has function format.
`Comparison(SQLFragment left, int comparator)` Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS and NOT EXISTS.
`Comparison(SQLFragment left, int comparator, SQLFragment right)` Constructs a new comparison fragment with the given expressions and comparator.

Method Summary

Methods
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.
`int`	`getComparator()` Returns the comparator for this comparison fragment.
`static java.lang.String`	`getComparatorText(int op)` Returns the comparator text for the given int.
`static int`	`getComparisonOperation(java.lang.String operator)` Returns the comparisson code for the given text.
`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.
`static boolean`	`isComparator(int op)`
`boolean`	`removeArgument(SQLFragment expression)`
`void`	`setArguments(SQLFragment[] arguments)` Sets the arguments for this function.
`void`	`setComparator(int 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, getDistinctText, getSeparator, 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 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
  - GREATER
```
public static final int GREATER
```
    Greater Than
    
    See Also:
    
    Constant Field Values
  - LESS
```
public static final int LESS
```
    Less Than
    
    See Also:
    
    Constant Field Values
  - GREATER_EQUAL
```
public static final int GREATER_EQUAL
```
    Greater Than Or Equal To
    
    See Also:
    
    Constant Field Values
  - LESS_EQUAL
```
public static final int LESS_EQUAL
```
    Less Than Or Equal To
    
    See Also:
    
    Constant Field Values
  - EQUAL
```
public static final int EQUAL
```
    Equal
    
    See Also:
    
    Constant Field Values
  - NOT_EQUAL
```
public static final int NOT_EQUAL
```
    Not Equal
    
    See Also:
    
    Constant Field Values
  - NULL
```
public static final int NULL
```
    Is Null
    
    See Also:
    
    Constant Field Values
  - NOT_NULL
```
public static final int NOT_NULL
```
    Is Not Null
    
    See Also:
    
    Constant Field Values
  - LIKE
```
public static final int LIKE
```
    Like
    
    See Also:
    
    Constant Field Values
  - NOT_LIKE
```
public static final int NOT_LIKE
```
    Not Like
    
    See Also:
    
    Constant Field Values
  - REGEXP_LIKE
```
public static final int REGEXP_LIKE
```
    regexp_like
    
    See Also:
    
    Constant Field Values
  - EXISTS
```
public static final int EXISTS
```
    Exists
    
    See Also:
    
    Constant Field Values
  - NOT_EXISTS
```
public static final int NOT_EXISTS
```
    Not Exists
    
    See Also:
    
    Constant Field Values
  - EQUAL_ANY
```
public static final int EQUAL_ANY
```
    See Also:
    
    Constant Field Values
  - NOT_EQUAL_ANY
```
public static final int NOT_EQUAL_ANY
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_ANY
```
public static final int GREATER_THAN_ANY
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_OR_EQUAL_ANY
```
public static final int GREATER_THAN_OR_EQUAL_ANY
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_ANY
```
public static final int LESS_THAN_ANY
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_OR_EQUAL_ANY
```
public static final int LESS_THAN_OR_EQUAL_ANY
```
    See Also:
    
    Constant Field Values
  - EQUAL_SOME
```
public static final int EQUAL_SOME
```
    See Also:
    
    Constant Field Values
  - NOT_EQUAL_SOME
```
public static final int NOT_EQUAL_SOME
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_SOME
```
public static final int GREATER_THAN_SOME
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_OR_EQUAL_SOME
```
public static final int GREATER_THAN_OR_EQUAL_SOME
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_SOME
```
public static final int LESS_THAN_SOME
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_OR_EQUAL_SOME
```
public static final int LESS_THAN_OR_EQUAL_SOME
```
    See Also:
    
    Constant Field Values
  - EQUAL_ALL
```
public static final int EQUAL_ALL
```
    See Also:
    
    Constant Field Values
  - NOT_EQUAL_ALL
```
public static final int NOT_EQUAL_ALL
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_ALL
```
public static final int GREATER_THAN_ALL
```
    See Also:
    
    Constant Field Values
  - GREATER_THAN_OR_EQUAL_ALL
```
public static final int GREATER_THAN_OR_EQUAL_ALL
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_ALL
```
public static final int LESS_THAN_ALL
```
    See Also:
    
    Constant Field Values
  - LESS_THAN_OR_EQUAL_ALL
```
public static final int LESS_THAN_OR_EQUAL_ALL
```
    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
  - Comparison
```
public Comparison()
```
    Constructs a new, empty, comparison object.
  - Comparison
```
public Comparison(SQLFragment left,
          int comparator)
```
    Left argument only constructor - used for IS NULL, IS NOT NULL, EXISTS and NOT EXISTS.
  - Comparison
```
public Comparison(int comparator,
          SQLFragment[] argsL)
```
    Constructs a new comparison fragment for regexp_like, which has function format.
  - Comparison
```
public Comparison(SQLFragment left,
          int comparator,
          SQLFragment right)
```
    Constructs a new comparison fragment with the given expressions and comparator.
- Method Detail
  - getComparator
```
public int 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(int 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
  - isComparator
```
public static boolean isComparator(int op)
```
  - getComparatorText
```
public static java.lang.String getComparatorText(int op)
```
    Returns the comparator text for the given int. Returns null if one of the static members isn't used.
  - getComparisonOperation
```
public static int getComparisonOperation(java.lang.String operator)
```
    Returns the comparisson code for the given text. Returns -1 if the text does not match a known comparisson

Class Comparison

Nested Class Summary

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

Field Summary

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

Fields inherited from interface oracle.javatools.db.sql.SQLFragment

Fields inherited from interface oracle.javatools.db.DBObject

Constructor Summary

Method Summary

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

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

Methods inherited from class oracle.javatools.db.AbstractChildBuildableObject

Methods inherited from class oracle.javatools.db.AbstractBuildableObject

Methods inherited from class oracle.javatools.db.AbstractDBObject

Methods inherited from class java.lang.Object

Methods inherited from interface oracle.javatools.db.ChildDBObject

Methods inherited from interface oracle.javatools.db.DBObject

Methods inherited from interface oracle.javatools.util.DynamicPropertySet

Field Detail

GREATER

LESS

GREATER_EQUAL

LESS_EQUAL

EQUAL

NOT_EQUAL

NULL

NOT_NULL

LIKE

NOT_LIKE

REGEXP_LIKE

EXISTS

NOT_EXISTS

EQUAL_ANY

NOT_EQUAL_ANY

GREATER_THAN_ANY

GREATER_THAN_OR_EQUAL_ANY

LESS_THAN_ANY

LESS_THAN_OR_EQUAL_ANY

EQUAL_SOME

NOT_EQUAL_SOME

GREATER_THAN_SOME

GREATER_THAN_OR_EQUAL_SOME

LESS_THAN_SOME

LESS_THAN_OR_EQUAL_SOME

EQUAL_ALL

NOT_EQUAL_ALL

GREATER_THAN_ALL

GREATER_THAN_OR_EQUAL_ALL

LESS_THAN_ALL

LESS_THAN_OR_EQUAL_ALL

NOT_IN

INTERSECT

UNION

MINUS

UNION_ALL

Constructor Detail

Comparison

Comparison

Comparison

Comparison

Method Detail

getComparator

getOperatorText

setComparator

getLeftExpression

setLeftExpression

getRightExpression

setRightExpression

setPriorOnLeft

getPriorOnLeft

setPriorOnRight

getPriorOnRight

checkNewSize

getSQLText

addArgument

addArgument

addArguments

getArgumentCount

setArguments

removeArgument