|
Oracle Fusion Middleware Java API Reference for Oracle TopLink 11g Release 1 (11.1.1) B32476-02 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.toplink.expressions.ExpressionOperator
public class ExpressionOperator
Purpose: ADVANCED: The expression operator is used internally to define SQL operations and functions. It is possible for an advanced user to define their own operators.
Field Summary | |
---|---|
static int |
Abs |
static int |
Acos |
static int |
Add |
static int |
AddDate |
static int |
AddMonths |
static int |
AggregateOperator |
static int |
All |
static int |
And Logical operators |
static int |
Any |
static int |
Ascending Ordering operators |
static int |
Ascii |
static int |
Asin |
static int |
Atan |
static int |
Atan2 |
static int |
Average |
static int |
Between |
static int |
Case |
static int |
Ceil |
static int |
CharIndex |
static int |
CharLength |
static int |
Chr |
static int |
ComparisonOperator |
static int |
Concat |
static int |
Cos |
static int |
Cosh |
static int |
Cot |
static int |
Count Aggregate operators |
static int |
CurrentDate |
static int |
CurrentTime |
static int |
DateDifference |
static int |
DateName |
static int |
DatePart |
static int |
DateToString |
static int |
Decode |
static int |
Deref |
static int |
Descending |
static int |
Difference |
static int |
Distinct |
static int |
Divide |
static int |
Equal Comparison operators |
static int |
EqualOuterJoin |
static int |
Exists |
static int |
ExistsNode |
static int |
Exp |
static int |
Extract |
static int |
ExtractValue |
static int |
Floor |
static int |
FunctionOperator |
static int |
GetNumberVal |
static int |
GetStringVal |
static int |
GreaterThan |
static int |
GreaterThanEqual |
static int |
Greatest |
static int |
HexToRaw |
static int |
In |
static int |
Initcap |
static int |
Instring |
static int |
InSubQuery |
static int |
IsFragment |
static int |
IsNull |
static int |
LastDay |
static int |
Least |
static int |
LeftPad |
static int |
LeftTrim |
static int |
LeftTrim2 |
static int |
Length |
static int |
LessThan |
static int |
LessThanEqual |
static int |
Like |
static int |
LikeEscape |
static int |
Ln |
static int |
Locate |
static int |
Locate2 |
static int |
Log |
static int |
LogicalOperator Operator types |
static int |
Maximum |
static int |
Minimum |
static int |
Mod |
static int |
MonthsBetween |
static int |
Multiply |
static int |
NewTime |
static int |
NextDay |
static int |
Not |
static int |
NotBetween |
static int |
NotEqual |
static int |
NotExists |
static int |
NotIn |
static int |
NotInSubQuery |
static int |
NotLike |
static int |
NotNull |
static int |
Nvl |
static int |
Or |
static int |
OrderOperator |
static int |
Power |
static int |
Ref |
static int |
RefToHex |
static int |
Replace |
static int |
Replicate |
static int |
Reverse |
static int |
Right |
static int |
RightPad |
static int |
RightTrim |
static int |
RightTrim2 |
static int |
Round |
static int |
RoundDate |
static int |
SDO_FILTER |
static int |
SDO_NN |
static int |
SDO_RELATE |
static int |
SDO_WITHIN_DISTANCE |
static int |
Sign |
static int |
Sin |
static int |
Sinh |
static int |
Some |
static int |
Soundex |
static int |
Sqrt |
static int |
StandardDeviation |
static int |
Substring |
static int |
Subtract |
static int |
Sum |
static int |
Tan |
static int |
Tanh |
static int |
ToChar |
static int |
ToCharWithFormat |
static int |
ToDate |
static int |
Today |
static int |
ToLowerCase |
static int |
ToNumber |
static int |
ToUpperCase Function operators |
static int |
Translate |
static int |
Trim |
static int |
Trim2 |
static int |
Trunc |
static int |
TruncateDate |
static int |
Value |
static int |
Variance |
Constructor Summary | |
---|---|
ExpressionOperator() ADVANCED: Create a new operator. |
|
ExpressionOperator(int selector, java.util.Vector newDatabaseStrings) ADVANCED: Create a new operator with the given name(s) and strings to print. |
Method Summary | |
---|---|
static void |
addOperator(ExpressionOperator exOperator) ADVANCED: Add an operator to the global list of operators. |
void |
bePostfix() ADVANCED: Tell the operator to be postfix, i.e. its strings start printing after those of its first argument. |
void |
bePrefix() ADVANCED: Tell the operator to be pretfix, i.e. its strings start printing before those of its first argument. |
static java.util.Map |
getAllOperators() ADVANCED: Return the hashtable of all operators. |
static ExpressionOperator |
getNumberVal() |
static ExpressionOperator |
getStringVal() |
int |
getType() ADVANCED: Return the type of function. |
boolean |
isAggregateOperator() Aggregate functions are function in the select such as COUNT. |
boolean |
isComparisonOperator() Comparison functions are functions such as = and >. |
static ExpressionOperator |
isFragment() |
boolean |
isFunctionOperator() General functions are any normal function such as UPPER. |
boolean |
isLogicalOperator() Logical functions are functions such as and and or. |
boolean |
isOrderOperator() Order functions are used in the order by such as ASC. |
boolean |
isPrefix() ADVANCED: Return true if this is a prefix operator. |
void |
printsAs(java.lang.String s) ADVANCED: Set the single string for this operator. |
void |
printsAs(java.util.Vector dbStrings) ADVANCED: Set the strings for this operator. |
void |
printsJavaAs(java.lang.String s) ADVANCED: Set the single string for this operator. |
void |
printsJavaAs(java.util.Vector dbStrings) ADVANCED: Set the strings for this operator. |
void |
setArgumentIndices(int[] indices) ADVANCED: Set the array of indexes to use when building the SQL function. |
void |
setNodeClass(java.lang.Class nodeClass) ADVANCED: Set the node class for this operator. |
void |
setType(int type) ADVANCED: Set the type of function. |
java.lang.String |
toString() Print a debug representation of this operator. |
Methods inherited from class java.lang.Object |
---|
getClass, notify, notifyAll, wait, wait, wait |
Field Detail |
---|
public static final int LogicalOperator
ExpressionOperator
public static final int ComparisonOperator
public static final int AggregateOperator
public static final int OrderOperator
public static final int FunctionOperator
public static final int And
ExpressionOperator
public static final int Or
public static final int Not
public static final int Equal
ExpressionOperator
public static final int NotEqual
public static final int EqualOuterJoin
public static final int LessThan
public static final int LessThanEqual
public static final int GreaterThan
public static final int GreaterThanEqual
public static final int Like
public static final int NotLike
public static final int In
public static final int InSubQuery
public static final int NotIn
public static final int NotInSubQuery
public static final int Between
public static final int NotBetween
public static final int IsNull
public static final int NotNull
public static final int Exists
public static final int NotExists
public static final int LikeEscape
public static final int Decode
public static final int Case
public static final int Count
ExpressionOperator
public static final int Sum
public static final int Average
public static final int Maximum
public static final int Minimum
public static final int StandardDeviation
public static final int Variance
public static final int Distinct
public static final int Ascending
ExpressionOperator
public static final int Descending
public static final int ToUpperCase
ExpressionOperator
public static final int ToLowerCase
public static final int Chr
public static final int Concat
public static final int HexToRaw
public static final int Initcap
public static final int Instring
public static final int Soundex
public static final int LeftPad
public static final int LeftTrim
public static final int Replace
public static final int RightPad
public static final int RightTrim
public static final int Substring
public static final int ToNumber
public static final int Translate
public static final int Trim
public static final int Ascii
public static final int Length
public static final int CharIndex
public static final int CharLength
public static final int Difference
public static final int Reverse
public static final int Replicate
public static final int Right
public static final int Locate
public static final int Locate2
public static final int ToChar
public static final int ToCharWithFormat
public static final int RightTrim2
public static final int Any
public static final int Some
public static final int All
public static final int Trim2
public static final int LeftTrim2
public static final int AddMonths
public static final int DateToString
public static final int LastDay
public static final int MonthsBetween
public static final int NextDay
public static final int RoundDate
public static final int ToDate
public static final int Today
public static final int AddDate
public static final int DateName
public static final int DatePart
public static final int DateDifference
public static final int TruncateDate
public static final int NewTime
public static final int Nvl
public static final int CurrentDate
public static final int CurrentTime
public static final int Ceil
public static final int Cos
public static final int Cosh
public static final int Abs
public static final int Acos
public static final int Asin
public static final int Atan
public static final int Exp
public static final int Sqrt
public static final int Floor
public static final int Ln
public static final int Log
public static final int Mod
public static final int Power
public static final int Round
public static final int Sign
public static final int Sin
public static final int Sinh
public static final int Tan
public static final int Tanh
public static final int Trunc
public static final int Greatest
public static final int Least
public static final int Add
public static final int Subtract
public static final int Divide
public static final int Multiply
public static final int Atan2
public static final int Cot
public static final int Deref
public static final int Ref
public static final int RefToHex
public static final int Value
public static final int Extract
public static final int ExtractValue
public static final int ExistsNode
public static final int GetStringVal
public static final int GetNumberVal
public static final int IsFragment
public static final int SDO_WITHIN_DISTANCE
public static final int SDO_RELATE
public static final int SDO_FILTER
public static final int SDO_NN
Constructor Detail |
---|
public ExpressionOperator()
public ExpressionOperator(int selector, java.util.Vector newDatabaseStrings)
Method Detail |
---|
public static void addOperator(ExpressionOperator exOperator)
public void bePostfix()
public void bePrefix()
public static ExpressionOperator getStringVal()
public static ExpressionOperator getNumberVal()
public static ExpressionOperator isFragment()
public static java.util.Map getAllOperators()
public int getType()
public boolean isAggregateOperator()
public boolean isComparisonOperator()
public boolean isFunctionOperator()
public boolean isLogicalOperator()
public boolean isOrderOperator()
public boolean isPrefix()
public void printsAs(java.lang.String s)
public void printsAs(java.util.Vector dbStrings)
public void printsJavaAs(java.lang.String s)
public void printsJavaAs(java.util.Vector dbStrings)
public void setArgumentIndices(int[] indices)
public void setNodeClass(java.lang.Class nodeClass)
A list of Operator types, an example, and the node class used follows.
LogicalOperator AND LogicalExpression
ComparisonOperator <> RelationExpression
AggregateOperator COUNT FunctionExpression
OrderOperator ASCENDING "
FunctionOperator RTRIM "
Node classes given belong to oracle.toplink.internal.expressions.
public void setType(int type)
public java.lang.String toString()
toString
in class java.lang.Object
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |