|
Oracle® OLAP Java API Reference 11g Release 1 (11.1) B28128-01 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.olapi.syntax.SyntaxObject
oracle.olapi.syntax.DataObject
oracle.olapi.syntax.Expression
oracle.olapi.syntax.TypedExpression
oracle.olapi.syntax.RowExpression
oracle.olapi.syntax.CaseExpression
oracle.olapi.syntax.SimpleCaseExpression
public final class SimpleCaseExpression
A CaseExpression
that represents an expression that is similar to the simple case expression and the ELSE
clauses of a CASE
expression in SQL. A SimpleCaseExpression
has a TypedExpression
as the expression of the simple case expression, SimpleCase
objects as the WHEN
and THEN
expressions of the simple case expression, and a TypedExpression
as the ELSE
clause.
When Oracle Database resolves a CASE
expression with a simple case expression clause, it searches for the first WHEN
expression that is equal to the expression of the simple case expression clause and returns the THEN
expression that is associated with that WHEN
expression.. If none of the WHEN
expressions meets this condition, and an ELSE
expression exists, then Oracle returns the ELSE
expression. Otherwise, Oracle returns null
. The value of every THEN
expression and the ELSE
expression cannot be null
.
Constructor Summary | |
---|---|
SimpleCaseExpression(TypedExpression switchExpression, java.util.List<SimpleCase> cases, TypedExpression elseExpression) Creates a SimpleCaseExpression that has a TypedExpression as the switch expression of the simple case expression clause of a CASE expression, a List of SimpleCase objects that contain the WHEN and THEN expressions of the simple case expression clause, and a TypedExpression as the ELSE clause of the CASE expression. |
|
SimpleCaseExpression(TypedExpression switchExpression, SimpleCase[] cases, TypedExpression elseExpression) Creates a SimpleCaseExpression that has a TypedExpression as the switch expression of the simple case expression clause of a CASE expression, an array of SimpleCase objects that contain the WHEN and THEN expressions of the simple case expression clause, and a TypedExpression as the ELSE clause of the CASE expression. |
Method Summary | |
---|---|
SimpleCase[] |
getCases() Gets the SimpleCase objects that contain the WHEN and THEN expressions of the simple case expression clause for this SimpleCaseExpression . |
TypedExpression |
getSwitchExpression() Gets the TypedExpression that resolves to the expression to which Oracle Database compares the THEN expressions of the SimpleCase objects of this SimpleCaseExpression . |
java.lang.Object |
visit(SyntaxObjectVisitor visitor, java.lang.Object context) Calls the visitSimpleCaseExpression method of the SyntaxObjectVisitor and passes that method this SimpleCaseExpression and an Object . |
Methods inherited from class oracle.olapi.syntax.CaseExpression |
---|
getElseExpression |
Methods inherited from class oracle.olapi.syntax.RowExpression |
---|
isCompositeObject |
Methods inherited from class oracle.olapi.syntax.Expression |
---|
getSource |
Methods inherited from class oracle.olapi.syntax.SyntaxObject |
---|
fromSyntax, fromSyntax, fromSyntax, fromSyntax, fromSyntax, isValid, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SimpleCaseExpression(TypedExpression switchExpression, SimpleCase[] cases, TypedExpression elseExpression)
SimpleCaseExpression
that has a TypedExpression
as the switch expression of the simple case expression clause of a CASE
expression, an array of SimpleCase
objects that contain the WHEN
and THEN
expressions of the simple case expression clause, and a TypedExpression
as the ELSE
clause of the CASE
expression.
switchExpression
- A TypedExpression
that resolves to the switch expression of the simple case expression of a CASE
expression.cases
- An array of SimpleCase
objects that resolve to the WHEN
and THEN
expressions of the simple case expression clause.elseExpression
- A TypedExpression
that resolves to the ELSE
expression of the CASE
expression.public SimpleCaseExpression(TypedExpression switchExpression, java.util.List<SimpleCase> cases, TypedExpression elseExpression)
SimpleCaseExpression
that has a TypedExpression
as the switch expression of the simple case expression clause of a CASE
expression, a List
of SimpleCase
objects that contain the WHEN
and THEN
expressions of the simple case expression clause, and a TypedExpression
as the ELSE
clause of the CASE
expression.
switchExpression
- A TypedExpression
that resolves to the switch expression of the simple case expression of a CASE
expression.cases
- A List
of SimpleCase
objects that resolve to the WHEN
and THEN
expressions of the simple case expression clause.elseExpression
- A TypedExpression
that resolves to the ELSE
expression of the CASE
expression.Method Detail |
---|
public java.lang.Object visit(SyntaxObjectVisitor visitor, java.lang.Object context)
visitSimpleCaseExpression
method of the SyntaxObjectVisitor
and passes that method this SimpleCaseExpression
and an Object
.visit
in class SyntaxObject
visitor
- A SyntaxObjectVisitor
.context
- An Object
.Object
returned by the visitSimpleCaseExpression
method.public SimpleCase[] getCases()
SimpleCase
objects that contain the WHEN
and THEN
expressions of the simple case expression clause for this SimpleCaseExpression
.SimpleCase
objects associated with this SimpleCaseExpression
.public TypedExpression getSwitchExpression()
TypedExpression
that resolves to the expression to which Oracle Database compares the THEN
expressions of the SimpleCase
objects of this SimpleCaseExpression
.String
that contains the switch expression of the simple case expression clause of the Case
expression.
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |