Skip navigation links

oracle.olapi.syntax
Class SearchedCaseExpression

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

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