public final class RowFunctionExpression extends RowExpression
RowExpression
that represents a row function, which is similar to a SQL single-row function. A SQL single-row function returns a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE
clauses, START WITH
and CONNECT BY
clauses, and HAVING
clauses.Constructor and Description |
---|
RowFunctionExpression(java.lang.String functionName)
Creates a
RowFunctionExpression that resolves to the specified row function with no arguments. |
RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified argument. |
RowFunctionExpression(java.lang.String functionName, FunctionArgument[] args)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified arguments. |
RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified arguments. |
RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2, FunctionArgument arg3)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified arguments. |
RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2, FunctionArgument arg3, FunctionArgument arg4)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified arguments. |
RowFunctionExpression(java.lang.String functionName, java.util.List<FunctionArgument> args)
Creates a
RowFunctionExpression that resolves to the specified row function with the specified arguments. |
Modifier and Type | Method and Description |
---|---|
FunctionArgument[] |
getArguments()
Gets the function arguments that are associated with this
RowFunctionExpression . |
FunctionDescriptor |
getFunctionDescriptor()
Gets the function descriptor that is associated with this
RowFunctionExpression . |
java.lang.String |
getFunctionName()
Gets the name of the row function that this
RowFunctionExpression represents. |
java.lang.Object |
visit(SyntaxObjectVisitor visitor, java.lang.Object context)
Calls the
visitRowFunctionExpression method of the SyntaxObjectVisitor and passes that method this RowFunctionExpression and an Object . |
isCompositeObject
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
equals, equals, fromSyntax, fromSyntax, fromSyntax, fromSyntax, fromSyntax, isValid, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax, toSyntax
public RowFunctionExpression(java.lang.String functionName, FunctionArgument[] args)
RowFunctionExpression
that resolves to the specified row function with the specified arguments.functionName
- A String
that contains the name of the row function.args
- An array of FunctionArgument
objects that affect the behavior of the function.public RowFunctionExpression(java.lang.String functionName, java.util.List<FunctionArgument> args)
RowFunctionExpression
that resolves to the specified row function with the specified arguments.functionName
- A String
that contains the name of the row function.args
- A List
of FunctionArgument
objects that affect the behavior of the function.public RowFunctionExpression(java.lang.String functionName)
RowFunctionExpression
that resolves to the specified row function with no arguments.functionName
- A String
that contains the name of the row function.public RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1)
RowFunctionExpression
that resolves to the specified row function with the specified argument.functionName
- A String
that contains the name of the row function.arg1
- A FunctionArgument
that is the only argument of the function.public RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2)
RowFunctionExpression
that resolves to the specified row function with the specified arguments.functionName
- A String
that contains the name of the row function.arg1
- A FunctionArgument
that is the first argument of the function.arg2
- A FunctionArgument
that is the second argument of the function.public RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2, FunctionArgument arg3)
RowFunctionExpression
that resolves to the specified row function with the specified arguments.functionName
- A String
that contains the name of the row function.arg1
- A FunctionArgument
that is the first argument of the function.arg2
- A FunctionArgument
that is the second argument of the function.arg3
- A FunctionArgument
that is the third argument of the function.public RowFunctionExpression(java.lang.String functionName, FunctionArgument arg1, FunctionArgument arg2, FunctionArgument arg3, FunctionArgument arg4)
RowFunctionExpression
that resolves to the specified row function with the specified arguments.functionName
- A String
that contains the name of the row function.arg1
- A FunctionArgument
that is the first argument of the function.arg2
- A FunctionArgument
that is the second argument of the function.arg3
- A FunctionArgument
that is the third argument of the function.arg4
- A FunctionArgument
that is the fourth argument of the function.public java.lang.Object visit(SyntaxObjectVisitor visitor, java.lang.Object context)
visitRowFunctionExpression
method of the SyntaxObjectVisitor
and passes that method this RowFunctionExpression
and an Object
.visit
in class SyntaxObject
visitor
- A SyntaxObjectVisitor
.context
- An Object
.Object
returned by the visitRowFunctionExpression
method.public FunctionArgument[] getArguments()
RowFunctionExpression
.FunctionArgument
objects associated with this RowFunctionExpression
.public FunctionDescriptor getFunctionDescriptor()
RowFunctionExpression
.FunctionDescriptor
associated with this RowFunctionExpression
.public java.lang.String getFunctionName()
RowFunctionExpression
represents.String
that contains the name of the row function of this RowFunctionExpression
.