|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.2.0) E17493-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
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.Comparison
public class Comparison
Subclass of Operation for comparisons. Operation only has two arguments - a left and right expression.
By default a Comparison object is EQUAL
Nested Class Summary |
---|
Nested classes/interfaces inherited from class oracle.javatools.db.AbstractDBObject |
---|
AbstractDBObject.ChildSupport, AbstractDBObject.ListenerSupport |
Field Summary | |
---|---|
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 |
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 | |
---|---|
Comparison() Constructs a new, empty, comparison object. |
|
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 | |
---|---|
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, 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 |
---|
public static final int GREATER
public static final int LESS
public static final int GREATER_EQUAL
public static final int LESS_EQUAL
public static final int EQUAL
public static final int NOT_EQUAL
public static final int NULL
public static final int NOT_NULL
public static final int LIKE
public static final int NOT_LIKE
public static final int EXISTS
public static final int NOT_EXISTS
public static final int EQUAL_ANY
public static final int NOT_EQUAL_ANY
public static final int GREATER_THAN_ANY
public static final int GREATER_THAN_OR_EQUAL_ANY
public static final int LESS_THAN_ANY
public static final int LESS_THAN_OR_EQUAL_ANY
public static final int EQUAL_SOME
public static final int NOT_EQUAL_SOME
public static final int GREATER_THAN_SOME
public static final int GREATER_THAN_OR_EQUAL_SOME
public static final int LESS_THAN_SOME
public static final int LESS_THAN_OR_EQUAL_SOME
public static final int EQUAL_ALL
public static final int NOT_EQUAL_ALL
public static final int GREATER_THAN_ALL
public static final int GREATER_THAN_OR_EQUAL_ALL
public static final int LESS_THAN_ALL
public static final int LESS_THAN_OR_EQUAL_ALL
public static final int NOT_IN
public static final int INTERSECT
public static final int UNION
public static final int MINUS
public static final int UNION_ALL
Constructor Detail |
---|
public Comparison()
public Comparison(SQLFragment left, int comparator)
public Comparison(SQLFragment left, int comparator, SQLFragment right)
Method Detail |
---|
public int getComparator()
public java.lang.String getOperatorText()
getOperatorText
in class Operation
public void setComparator(int comparator)
public SQLFragment getLeftExpression()
public void setLeftExpression(SQLFragment leftExpression)
public SQLFragment getRightExpression()
public void setRightExpression(SQLFragment rightExpression)
public void setPriorOnLeft(boolean priorOnLeft)
public boolean getPriorOnLeft()
public void setPriorOnRight(boolean priorOnRight)
public boolean getPriorOnRight()
protected void checkNewSize(int proposedSize)
Operation
checkNewSize
in class Operation
public java.lang.String getSQLText()
Operation
getSQLText
in interface SQLFragment
getSQLText
in class Operation
public void addArgument(int index, SQLFragment expression)
addArgument
in class Operation
public void addArgument(SQLFragment expression)
addArgument
in class Operation
public void addArguments(SQLFragment[] expressions)
addArguments
in class Operation
public int getArgumentCount()
Operation
getArgumentCount
in class Operation
public void setArguments(SQLFragment[] arguments)
Operation
setArguments
in class Operation
public boolean removeArgument(SQLFragment expression)
removeArgument
in class Operation
public SQLFragment[] getArguments()
Operation
getArguments
in class Operation
public static boolean isComparator(int op)
public static java.lang.String getComparatorText(int op)
public static int getComparisonOperation(java.lang.String operator)
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.2.0) E17493-03 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |