|
Oracle® OLAP Java API Reference 11g Release 2 (11.2) E10794-06 |
||||||||
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.SearchedCaseExpression
public final class SearchedCaseExpression
A CaseExpression
that represents an expression that is similar to the searched case expression clause and the ELSE
clause of a CASE
expression in SQL. A SearchedCaseExpression
has SearchedCase
objects that each resolves to a WHEN
condition and THEN
expression of the searched case expression clause, and a TypedExpression
that resolves to the ELSE
clause.
When Oracle Database resolves a CASE
expression with a searched case expression clause, it searches for the first condition that is true and returns the THEN
expression that is associated with that WHEN
condition. If none of the conditions are true and an ELSE
expression exists, then Oracle returns the ELSE
expression. Otherwise, Oracle returns null
.
Constructor Summary | |
---|---|
SearchedCaseExpression(java.util.List<SearchedCase> cases, TypedExpression elseExpression) Creates a SearchedCaseExpression that has a List of SearchedCase objects that contain the WHEN conditions and the THEN expressions of a searched case expression clause, and a TypedExpression that is the ELSE clause of a CASE expression. |
|
SearchedCaseExpression(SearchedCase[] cases, TypedExpression elseExpression) Creates a SearchedCaseExpression that has an array of SearchedCase objects that contain the WHEN conditions and the THEN expressions of a searched case expression clause, and a TypedExpression that is the ELSE clause of a CASE expression. |
Method Summary | |
---|---|
SearchedCase[] |
getCases() Gets the SearchedCase objects that contain the WHEN conditions and THEN expressions of the searched case expression clause for this SearchedCaseExpression . |
java.lang.Object |
visit(SyntaxObjectVisitor visitor, java.lang.Object context) Calls the visitSearchedCaseExpression method of the SyntaxObjectVisitor and passes that method this SearchedCaseExpression 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.SyntaxObject |
---|
equals, equals, fromSyntax, fromSyntax, fromSyntax, fromSyntax, fromSyntax, isValid, toSyntax, 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 SearchedCaseExpression(SearchedCase[] cases, TypedExpression elseExpression)
SearchedCaseExpression
that has an array of SearchedCase
objects that contain the WHEN
conditions and the THEN
expressions of a searched case expression clause, and a TypedExpression
that is the ELSE
clause of a CASE
expression.
cases
- An array of SearchedCase
objects that resolve to the WHEN
conditions and THEN
expressions of the searched case expression clause.elseExpression
- A TypedExpression
that resolves to the ELSE
expression of the CASE
expression.public SearchedCaseExpression(java.util.List<SearchedCase> cases, TypedExpression elseExpression)
SearchedCaseExpression
that has a List
of SearchedCase
objects that contain the WHEN
conditions and the THEN
expressions of a searched case expression clause, and a TypedExpression
that is the ELSE
clause of a CASE
expression.
cases
- A List
of SearchedCase
objects that resolve to the WHEN
conditions and the THEN
expressions of the searched 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)
visitSearchedCaseExpression
method of the SyntaxObjectVisitor
and passes that method this SearchedCaseExpression
and an Object
.visit
in class SyntaxObject
visitor
- A SyntaxObjectVisitor
.context
- An Object
.Object
returned by the visitSearchedCaseExpression
method.public SearchedCase[] getCases()
SearchedCase
objects that contain the WHEN
conditions and THEN
expressions of the searched case expression clause for this SearchedCaseExpression
.SearchedCase
objects associated with this SearchedCaseExpression
.
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |