Skip navigation links

Oracle® OLAP Java API Reference
11g Release 2 (11.2)

E10794-05


oracle.olapi.syntax
Class SearchedCaseExpression

java.lang.Object
  extended by oracle.olapi.syntax.SyntaxObject
      extended by oracle.olapi.syntax.DataObject
          extended by oracle.olapi.syntax.Expression
              extended by oracle.olapi.syntax.TypedExpression
                  extended by oracle.olapi.syntax.RowExpression
                      extended by oracle.olapi.syntax.CaseExpression
                          extended by oracle.olapi.syntax.SearchedCaseExpression

All Implemented Interfaces:
FunctionArgument

public final class SearchedCaseExpression
extends CaseExpression

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.TypedExpression
abs, acos, addMonths, addMonths, ascii, asciiStr, asin, atan, atan2, between, binToNum, bitAnd, cast, ceil, charToROWID, chr, chr, coalesce, compose, concat, concat, convert, convert, cos, cosh, currentDate, currentTime, dbTimeZone, decode, decompose, deref, div, div, div, div, div, dump, eq, eq, eq, eq, eq, exp, extractDay, extractHour, extractMinute, extractMonth, extractSecond, extractTimeZoneAbbr, extractTimeZoneHour, extractTimeZoneMinute, extractTimeZoneRegion, extractYear, floor, fromTZ, ge, ge, ge, ge, ge, getDataType, greatest, gt, gt, gt, gt, gt, hexToRAW, in, initcap, instr, instr2, instr4, instrB, instrC, isInfinite, isNAN, isNotNull, isNull, lastDay, le, le, le, le, le, least, length, length2, length4, lengthB, lengthC, like, like, like2, like4, likeC, ln, localTimestamp, log, lower, lpad, lt, lt, lt, lt, lt, ltrim, minus, minus, minus, minus, minus, minus, mod, monthsBetween, nanvl, ne, ne, ne, ne, ne, newTime, nextDay, nlsCharsetDeclLen, nlsCharsetID, nlsCharsetName, nlsInitcap, nlsLower, nlsSort, nlsUpper, notIn, nullIf, numToDSInterval, numToYMInterval, nvl, nvl2, oraHash, plus, plus, plus, plus, plus, power, rawToHex, rawToNHex, regexpInstr, regexpReplace, regexpSubstr, remainder, replace, round, rowIDToChar, rowIDToNChar, rpad, rtrim, scnToTimestamp, sessionTimeZone, sign, sin, sinh, soundex, sqrt, substr, substr2, substr4, substrB, substrC, sysContext, sysDate, sysExtractUTC, sysGUID, sysTimestamp, sysTypeID, tan, tanh, times, times, times, times, times, timestampToSCN, toBinaryDouble, toBinaryFloat, toChar, toChar, toCLOB, toDate, toDate, toDSInterval, toLOB, toMultiByte, toNChar, toNChar, toNCLOB, toNumber, toNumber, toNumber, toSingleByte, toTimestamp, toTimestampTZ, toYMInterval, translate, translateUsingCharCS, translateUsingNCharCS, treat, trim, trimLeading, trimTrailing, trunc, tzOffset, UID, unistr, upper, USER, userEnv, vsize, widthBucket

 

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

SearchedCaseExpression

public 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.
Parameters:
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.

SearchedCaseExpression

public 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.
Parameters:
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

visit

public 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.
Specified by:
visit in class SyntaxObject
Parameters:
visitor - A SyntaxObjectVisitor.
context - An Object.
Returns:
The Object returned by the visitSearchedCaseExpression method.

getCases

public SearchedCase[] getCases()
Gets the SearchedCase objects that contain the WHEN conditions and THEN expressions of the searched case expression clause for this SearchedCaseExpression.
Returns:
An array of the SearchedCase objects associated with this SearchedCaseExpression.

Skip navigation links

Copyright © 2002, 2010, Oracle. All rights reserved.