Skip navigation links

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

E10794-05


oracle.olapi.syntax
Class FunctionDescriptorCatalog

java.lang.Object
  extended by oracle.olapi.syntax.FunctionDescriptorCatalog


public final class FunctionDescriptorCatalog
extends java.lang.Object

A catalog of functions that are represented by Expression objects. The FunctionDescriptorCatalog class has fields that represent FunctionDescriptor objects. When an application explicitly or implicitly creates an Expression for a function, Oracle OLAP creates a FunctionDescriptor for the function. The FunctionDescriptor has FunctionDescriptorArgument objects that describe the arguments of the function.

The FunctionDescriptorCatalog class also has fields that represent categories of functions. For example, the CHARACTER_CATEGORY field represents functions that operate on objects with the data type such as DataType.TEXT_CATEGORY or DataType.TEXT_LITERAL_CATEGORY.


Field Summary
static FunctionDescriptor ABS
          A static constant FunctionDescriptor representing the function ABS.
static FunctionDescriptor ACOS
          A static constant FunctionDescriptor representing the function ACOS.
static FunctionDescriptor ADD_MONTHS
          A static constant FunctionDescriptor representing the function ADD_MONTHS.
static FunctionDescriptor AGGREGATE
          A static constant FunctionDescriptor representing the function AGGREGATE.
static FunctionDescriptor AGGREGATION_AVG
          A static constant FunctionDescriptor representing the function AVG.
static java.lang.String AGGREGATION_CATEGORY
          A static constant String for the AGGREGATION category of functions.
static FunctionDescriptor AGGREGATION_FIRST
          A static constant FunctionDescriptor representing the function FIRST.
static FunctionDescriptor AGGREGATION_LAST
          A static constant FunctionDescriptor representing the function LAST.
static FunctionDescriptor AGGREGATION_MAX
          A static constant FunctionDescriptor representing the function MAX.
static FunctionDescriptor AGGREGATION_MIN
          A static constant FunctionDescriptor representing the function MIN.
static FunctionDescriptor AGGREGATION_SUM
          A static constant FunctionDescriptor representing the function SUM.
static FunctionDescriptor ASCII
          A static constant FunctionDescriptor representing the function ASCII.
static FunctionDescriptor ASCIISTR
          A static constant FunctionDescriptor representing the function ASCIISTR.
static FunctionDescriptor ASIN
          A static constant FunctionDescriptor representing the function ASIN.
static FunctionDescriptor ATAN
          A static constant FunctionDescriptor representing the function ATAN.
static FunctionDescriptor ATAN2
          A static constant FunctionDescriptor representing the function ATAN2.
static FunctionDescriptor AVERAGE_RANK
          A static constant FunctionDescriptor representing the function AVERAGE_RANK.
static FunctionDescriptor BIN_TO_NUM
          A static constant FunctionDescriptor representing the function BIN_TO_NUM.
static FunctionDescriptor BITAND
          A static constant FunctionDescriptor representing the function BITAND.
static FunctionDescriptor CAST
          A static constant FunctionDescriptor representing the function CAST.
static FunctionDescriptor CEIL
          A static constant FunctionDescriptor representing the function CEIL.
static FunctionDescriptor CHAR_TO_CHAR
          A static constant FunctionDescriptor representing the function TO_CHAR.
static FunctionDescriptor CHAR_TO_NCHAR
          A static constant FunctionDescriptor representing the function TO_NCHAR.
static java.lang.String CHARACTER_CATEGORY
          A static constant String for the CHARACTER category of functions.
static FunctionDescriptor CHARTOROWID
          A static constant FunctionDescriptor representing the function CHARTOROWID.
static FunctionDescriptor CHR
          A static constant FunctionDescriptor representing the function CHR.
static FunctionDescriptor COALESCE
          A static constant FunctionDescriptor representing the function COALESCE.
static java.lang.String COMPARISON_CATEGORY
          A static constant String for the COMPARISON category of functions.
static FunctionDescriptor COMPOSE
          A static constant FunctionDescriptor representing the function COMPOSE.
static FunctionDescriptor CONCAT
          A static constant FunctionDescriptor representing the function CONCAT.
static java.lang.String CONVERSION_CATEGORY
          A static constant String for the CONVERSION category of functions.
static FunctionDescriptor CONVERT
          A static constant FunctionDescriptor representing the function CONVERT.
static FunctionDescriptor COS
          A static constant FunctionDescriptor representing the function COS.
static FunctionDescriptor COSH
          A static constant FunctionDescriptor representing the function COSH.
static FunctionDescriptor CURRENT_DATE
          A static constant FunctionDescriptor representing the function CURRENT_DATE.
static FunctionDescriptor CURRENT_TIMESTAMP
          A static constant FunctionDescriptor representing the function CURRENT_TIMESTAMP.
static java.lang.String DATETIME_CATEGORY
          A static constant String for the DATETIME category of functions.
static FunctionDescriptor DATETIME_TO_CHAR
          A static constant FunctionDescriptor representing the function TO_CHAR.
static FunctionDescriptor DATETIME_TO_NCHAR
          A static constant FunctionDescriptor representing the function TO_NCHAR.
static FunctionDescriptor DBTIMEZONE
          A static constant FunctionDescriptor representing the function DBTIMEZONE.
static FunctionDescriptor DECODE
          A static constant FunctionDescriptor representing the function DECODE.
static FunctionDescriptor DECOMPOSE
          A static constant FunctionDescriptor representing the function DECOMPOSE.
static FunctionDescriptor DENSE_RANK
          A static constant FunctionDescriptor representing the function DENSE_RANK.
static FunctionDescriptor DUMP
          A static constant FunctionDescriptor representing the function DUMP.
static java.lang.String ENCODING_CATEGORY
          A static constant String for the ENCODING category of functions.
static java.lang.String ENVIRONMENT_CATEGORY
          A static constant String for the ENVIRONMENT category of functions.
static FunctionDescriptor EXP
          A static constant FunctionDescriptor representing the function EXP.
static FunctionDescriptor EXTRACT_DATE
          A static constant FunctionDescriptor representing the function EXTRACT.
static FunctionDescriptor FLOOR
          A static constant FunctionDescriptor representing the function FLOOR.
static FunctionDescriptor FROM_TZ
          A static constant FunctionDescriptor representing the function FROM_TZ.
static FunctionDescriptor GREATEST
          A static constant FunctionDescriptor representing the function GREATEST.
static FunctionDescriptor HEXTORAW
          A static constant FunctionDescriptor representing the function HEXTORAW.
static FunctionDescriptor HIER_ANCESTOR
          A static constant FunctionDescriptor representing the function HIER_ANCESTOR.
static FunctionDescriptor HIER_ANCESTORS
          A static constant FunctionDescriptor representing the function HIER_ANCESTORS.
static FunctionDescriptor HIER_AVG
          A static constant FunctionDescriptor representing the function HIER_AVG.
static FunctionDescriptor HIER_CHILD_COUNT
          A static constant FunctionDescriptor representing the function HIER_CHILD_COUNT.
static FunctionDescriptor HIER_CHILDREN
          A static constant FunctionDescriptor representing the function HIER_CHILDREN.
static FunctionDescriptor HIER_DEPTH
          A static constant FunctionDescriptor representing the function HIER_DEPTH.
static FunctionDescriptor HIER_DESCENDANTS
          A static constant FunctionDescriptor representing the function HIER_DESCENDANTS.
static FunctionDescriptor HIER_FIRST
          A static constant FunctionDescriptor representing the function HIER_FIRST.
static FunctionDescriptor HIER_HAS_CHILDREN
          A static constant FunctionDescriptor representing the function HIER_HAS_CHILDREN.
static FunctionDescriptor HIER_LAST
          A static constant FunctionDescriptor representing the function HIER_LAST.
static FunctionDescriptor HIER_LEAF_DESCENDANTS
          A static constant FunctionDescriptor representing the function HIER_LEAF_DESCENDANTS.
static FunctionDescriptor HIER_LEVEL
          A static constant FunctionDescriptor representing the function HIER_LEVEL.
static FunctionDescriptor HIER_ORDER
          A static constant FunctionDescriptor representing the function HIER_ORDER.
static FunctionDescriptor HIER_PARENT
          A static constant FunctionDescriptor representing the function HIER_PARENT.
static FunctionDescriptor HIER_SIBLINGS
          A static constant FunctionDescriptor representing the function HIER_SIBLINGS.
static FunctionDescriptor HIER_TOP
          A static constant FunctionDescriptor representing the function HIER_TOP.
static java.lang.String HIERARCHICAL_CATEGORY
          A static constant String for the HIERARCHICAL category of functions.
static FunctionDescriptor INITCAP
          A static constant FunctionDescriptor representing the function INITCAP.
static FunctionDescriptor INSTR
          A static constant FunctionDescriptor representing the function INSTR.
static FunctionDescriptor INSTR2
          A static constant FunctionDescriptor representing the function INSTR2.
static FunctionDescriptor INSTR4
          A static constant FunctionDescriptor representing the function INSTR4.
static FunctionDescriptor INSTRB
          A static constant FunctionDescriptor representing the function INSTRB.
static FunctionDescriptor INSTRC
          A static constant FunctionDescriptor representing the function INSTRC.
static FunctionDescriptor INTERVAL_TO_CHAR
          A static constant FunctionDescriptor representing the function TO_CHAR.
static FunctionDescriptor INTERVAL_TO_NCHAR
          A static constant FunctionDescriptor representing the function TO_NCHAR.
static FunctionDescriptor LAG
          A static constant FunctionDescriptor representing the function LAG.
static FunctionDescriptor LAG_VARIANCE
          A static constant FunctionDescriptor representing the function LAG_VARIANCE.
static FunctionDescriptor LAG_VARIANCE_PERCENT
          A static constant FunctionDescriptor representing the function LAG_VARIANCE_PERCENT.
static FunctionDescriptor LAST_DAY
          A static constant FunctionDescriptor representing the function LAST_DAY.
static FunctionDescriptor LEAD
          A static constant FunctionDescriptor representing the function LEAD.
static FunctionDescriptor LEAD_VARIANCE
          A static constant FunctionDescriptor representing the function LEAD_VARIANCE.
static FunctionDescriptor LEAD_VARIANCE_PERCENT
          A static constant FunctionDescriptor representing the function LEAD_VARIANCE_PERCENT.
static FunctionDescriptor LEAST
          A static constant FunctionDescriptor representing the function LEAST.
static FunctionDescriptor LENGTH
          A static constant FunctionDescriptor representing the function LENGTH.
static FunctionDescriptor LENGTH2
          A static constant FunctionDescriptor representing the function LENGTH2.
static FunctionDescriptor LENGTH4
          A static constant FunctionDescriptor representing the function LENGTH4.
static FunctionDescriptor LENGTHB
          A static constant FunctionDescriptor representing the function LENGTHB.
static FunctionDescriptor LENGTHC
          A static constant FunctionDescriptor representing the function LENGTHC.
static FunctionDescriptor LN
          A static constant FunctionDescriptor representing the function LN.
static FunctionDescriptor LNNVL
          A static constant FunctionDescriptor representing the function LNNVL.
static FunctionDescriptor LOCALTIMESTAMP
          A static constant FunctionDescriptor representing the function LOCALTIMESTAMP.
static FunctionDescriptor LOG
          A static constant FunctionDescriptor representing the function LOG.
static FunctionDescriptor LOWER
          A static constant FunctionDescriptor representing the function LOWER.
static FunctionDescriptor LPAD
          A static constant FunctionDescriptor representing the function LPAD.
static FunctionDescriptor LTRIM
          A static constant FunctionDescriptor representing the function LTRIM.
static FunctionDescriptor MOD
          A static constant FunctionDescriptor representing the function MOD.
static FunctionDescriptor MONTHS_BETWEEN
          A static constant FunctionDescriptor representing the function MONTHS_BETWEEN.
static FunctionDescriptor NANVL
          A static constant FunctionDescriptor representing the function NANVL.
static FunctionDescriptor NEW_TIME
          A static constant FunctionDescriptor representing the function NEW_TIME.
static FunctionDescriptor NEXT_DAY
          A static constant FunctionDescriptor representing the function NEXT_DAY.
static java.lang.String NLS_CATEGORY
          A static constant String for the NLS category of functions.
static FunctionDescriptor NLS_CHARSET_DECL_LEN
          A static constant FunctionDescriptor representing the function NLS_CHARSET_DECL_LEN.
static FunctionDescriptor NLS_CHARSET_ID
          A static constant FunctionDescriptor representing the function NLS_CHARSET_ID.
static FunctionDescriptor NLS_CHARSET_NAME
          A static constant FunctionDescriptor representing the function NLS_CHARSET_NAME.
static FunctionDescriptor NLS_INITCAP
          A static constant FunctionDescriptor representing the function NLS_INITCAP.
static FunctionDescriptor NLS_LOWER
          A static constant FunctionDescriptor representing the function NLS_LOWER.
static FunctionDescriptor NLS_UPPER
          A static constant FunctionDescriptor representing the function NLS_UPPER.
static FunctionDescriptor NLSSORT
          A static constant FunctionDescriptor representing the function NLSSORT.
static java.lang.String NULL_RELATED_CATEGORY
          A static constant String for the NULL RELATED category of functions.
static FunctionDescriptor NULLIF
          A static constant FunctionDescriptor representing the function NULLIF.
static FunctionDescriptor NUMBER_TO_CHAR
          A static constant FunctionDescriptor representing the function TO_CHAR.
static FunctionDescriptor NUMBER_TO_NCHAR
          A static constant FunctionDescriptor representing the function TO_NCHAR.
static java.lang.String NUMERIC_CATEGORY
          A static constant String for the NUMERIC category of functions.
static FunctionDescriptor NUMTODSINTERVAL
          A static constant FunctionDescriptor representing the function NUMTODSINTERVAL.
static FunctionDescriptor NUMTOYMINTERVAL
          A static constant FunctionDescriptor representing the function NUMTOYMINTERVAL.
static FunctionDescriptor NVL
          A static constant FunctionDescriptor representing the function NVL.
static FunctionDescriptor NVL2
          A static constant FunctionDescriptor representing the function NVL2.
static FunctionDescriptor OLAP_AVG
          A static constant FunctionDescriptor representing the function AVG.
static FunctionDescriptor OLAP_COUNT
          A static constant FunctionDescriptor representing the function COUNT.
static FunctionDescriptor OLAP_MAX
          A static constant FunctionDescriptor representing the function MAX.
static FunctionDescriptor OLAP_MIN
          A static constant FunctionDescriptor representing the function MIN.
static FunctionDescriptor OLAP_SUM
          A static constant FunctionDescriptor representing the function SUM.
static FunctionDescriptor ORA_HASH
          A static constant FunctionDescriptor representing the function ORA_HASH.
static FunctionDescriptor POWER
          A static constant FunctionDescriptor representing the function POWER.
static FunctionDescriptor RANK
          A static constant FunctionDescriptor representing the function RANK.
static FunctionDescriptor RAWTOHEX
          A static constant FunctionDescriptor representing the function RAWTOHEX.
static FunctionDescriptor RAWTONHEX
          A static constant FunctionDescriptor representing the function RAWTONHEX.
static FunctionDescriptor REGEXP_COUNT
          A static constant FunctionDescriptor representing the function REGEXP_COUNT.
static FunctionDescriptor REGEXP_INSTR
          A static constant FunctionDescriptor representing the function REGEXP_INSTR.
static FunctionDescriptor REGEXP_REPLACE
          A static constant FunctionDescriptor representing the function REGEXP_REPLACE.
static FunctionDescriptor REGEXP_SUBSTR
          A static constant FunctionDescriptor representing the function REGEXP_SUBSTR.
static FunctionDescriptor REMAINDER
          A static constant FunctionDescriptor representing the function REMAINDER.
static FunctionDescriptor REPLACE
          A static constant FunctionDescriptor representing the function REPLACE.
static FunctionDescriptor ROUND_DATE
          A static constant FunctionDescriptor representing the function ROUND.
static FunctionDescriptor ROUND_NUMBER
          A static constant FunctionDescriptor representing the function ROUND.
static FunctionDescriptor ROW_NUMBER
          A static constant FunctionDescriptor representing the function ROW_NUMBER.
static FunctionDescriptor ROWIDTOCHAR
          A static constant FunctionDescriptor representing the function ROWIDTOCHAR.
static FunctionDescriptor ROWIDTONCHAR
          A static constant FunctionDescriptor representing the function ROWIDTONCHAR.
static FunctionDescriptor RPAD
          A static constant FunctionDescriptor representing the function RPAD.
static FunctionDescriptor RTRIM
          A static constant FunctionDescriptor representing the function RTRIM.
static FunctionDescriptor SCN_TO_TIMESTAMP
          A static constant FunctionDescriptor representing the function SCN_TO_TIMESTAMP.
static FunctionDescriptor SESSIONTIMEZONE
          A static constant FunctionDescriptor representing the function SESSIONTIMEZONE.
static FunctionDescriptor SHARE
          A static constant FunctionDescriptor representing the function SHARE.
static FunctionDescriptor SIGN
          A static constant FunctionDescriptor representing the function SIGN.
static FunctionDescriptor SIN
          A static constant FunctionDescriptor representing the function SIN.
static FunctionDescriptor SINH
          A static constant FunctionDescriptor representing the function SINH.
static java.lang.String SOLVE_CATEGORY
          A static constant String for the SOLVE category of functions.
static FunctionDescriptor SOUNDEX
          A static constant FunctionDescriptor representing the function SOUNDEX.
static FunctionDescriptor SQRT
          A static constant FunctionDescriptor representing the function SQRT.
static FunctionDescriptor SUBSTR
          A static constant FunctionDescriptor representing the function SUBSTR.
static FunctionDescriptor SUBSTR2
          A static constant FunctionDescriptor representing the function SUBSTR2.
static FunctionDescriptor SUBSTR4
          A static constant FunctionDescriptor representing the function SUBSTR4.
static FunctionDescriptor SUBSTRB
          A static constant FunctionDescriptor representing the function SUBSTRB.
static FunctionDescriptor SUBSTRC
          A static constant FunctionDescriptor representing the function SUBSTRC.
static FunctionDescriptor SYS_CONTEXT
          A static constant FunctionDescriptor representing the function SYS_CONTEXT.
static FunctionDescriptor SYS_EXTRACT_UTC
          A static constant FunctionDescriptor representing the function SYS_EXTRACT_UTC.
static FunctionDescriptor SYS_GUID
          A static constant FunctionDescriptor representing the function SYS_GUID.
static FunctionDescriptor SYS_TYPEID
          A static constant FunctionDescriptor representing the function SYS_TYPEID.
static FunctionDescriptor SYSDATE
          A static constant FunctionDescriptor representing the function SYSDATE.
static FunctionDescriptor SYSTIMESTAMP
          A static constant FunctionDescriptor representing the function SYSTIMESTAMP.
static FunctionDescriptor TAN
          A static constant FunctionDescriptor representing the function TAN.
static FunctionDescriptor TANH
          A static constant FunctionDescriptor representing the function TANH.
static FunctionDescriptor TIMESTAMP_TO_SCN
          A static constant FunctionDescriptor representing the function TIMESTAMP_TO_SCN.
static FunctionDescriptor TO_BINARY_DOUBLE
          A static constant FunctionDescriptor representing the function TO_BINARY_DOUBLE.
static FunctionDescriptor TO_BINARY_FLOAT
          A static constant FunctionDescriptor representing the function TO_BINARY_FLOAT.
static FunctionDescriptor TO_CLOB
          A static constant FunctionDescriptor representing the function TO_CLOB.
static FunctionDescriptor TO_DATE
          A static constant FunctionDescriptor representing the function TO_DATE.
static FunctionDescriptor TO_DSINTERVAL
          A static constant FunctionDescriptor representing the function TO_DSINTERVAL.
static FunctionDescriptor TO_LOB
          A static constant FunctionDescriptor representing the function TO_LOB.
static FunctionDescriptor TO_MULTI_BYTE
          A static constant FunctionDescriptor representing the function TO_MULTI_BYTE.
static FunctionDescriptor TO_NCLOB
          A static constant FunctionDescriptor representing the function TO_NCLOB.
static FunctionDescriptor TO_NUMBER
          A static constant FunctionDescriptor representing the function TO_NUMBER.
static FunctionDescriptor TO_SINGLE_BYTE
          A static constant FunctionDescriptor representing the function TO_SINGLE_BYTE.
static FunctionDescriptor TO_TIMESTAMP
          A static constant FunctionDescriptor representing the function TO_TIMESTAMP.
static FunctionDescriptor TO_TIMESTAMP_TZ
          A static constant FunctionDescriptor representing the function TO_TIMESTAMP_TZ.
static FunctionDescriptor TO_YMINTERVAL
          A static constant FunctionDescriptor representing the function TO_YMINTERVAL.
static FunctionDescriptor TRANSLATE
          A static constant FunctionDescriptor representing the function TRANSLATE.
static FunctionDescriptor TRANSLATE_USING
          A static constant FunctionDescriptor representing the function TRANSLATE.
static FunctionDescriptor TREAT
          A static constant FunctionDescriptor representing the function TREAT.
static FunctionDescriptor TRIM
          A static constant FunctionDescriptor representing the function TRIM.
static FunctionDescriptor TRUNC
          A static constant FunctionDescriptor representing the function TRUNC.
static FunctionDescriptor TZ_OFFSET
          A static constant FunctionDescriptor representing the function TZ_OFFSET.
static FunctionDescriptor UID
          A static constant FunctionDescriptor representing the function UID.
static FunctionDescriptor UNISTR
          A static constant FunctionDescriptor representing the function UNISTR.
static FunctionDescriptor UPPER
          A static constant FunctionDescriptor representing the function UPPER.
static FunctionDescriptor USER
          A static constant FunctionDescriptor representing the function USER.
static FunctionDescriptor USERENV
          A static constant FunctionDescriptor representing the function USERENV.
static FunctionDescriptor VSIZE
          A static constant FunctionDescriptor representing the function VSIZE.
static FunctionDescriptor WIDTH_BUCKET
          A static constant FunctionDescriptor representing the function WIDTH_BUCKET.
static java.lang.String WINDOW_CATEGORY
          A static constant String for the WINDOW category of functions.

 

Method Summary

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

HIERARCHICAL_CATEGORY

public static final java.lang.String HIERARCHICAL_CATEGORY
A static constant String for the HIERARCHICAL category of functions.
See Also:
Constant Field Values

WINDOW_CATEGORY

public static final java.lang.String WINDOW_CATEGORY
A static constant String for the WINDOW category of functions.
See Also:
Constant Field Values

NUMERIC_CATEGORY

public static final java.lang.String NUMERIC_CATEGORY
A static constant String for the NUMERIC category of functions.
See Also:
Constant Field Values

CHARACTER_CATEGORY

public static final java.lang.String CHARACTER_CATEGORY
A static constant String for the CHARACTER category of functions.
See Also:
Constant Field Values

NLS_CATEGORY

public static final java.lang.String NLS_CATEGORY
A static constant String for the NLS category of functions.
See Also:
Constant Field Values

DATETIME_CATEGORY

public static final java.lang.String DATETIME_CATEGORY
A static constant String for the DATETIME category of functions.
See Also:
Constant Field Values

COMPARISON_CATEGORY

public static final java.lang.String COMPARISON_CATEGORY
A static constant String for the COMPARISON category of functions.
See Also:
Constant Field Values

CONVERSION_CATEGORY

public static final java.lang.String CONVERSION_CATEGORY
A static constant String for the CONVERSION category of functions.
See Also:
Constant Field Values

ENCODING_CATEGORY

public static final java.lang.String ENCODING_CATEGORY
A static constant String for the ENCODING category of functions.
See Also:
Constant Field Values

NULL_RELATED_CATEGORY

public static final java.lang.String NULL_RELATED_CATEGORY
A static constant String for the NULL RELATED category of functions.
See Also:
Constant Field Values

ENVIRONMENT_CATEGORY

public static final java.lang.String ENVIRONMENT_CATEGORY
A static constant String for the ENVIRONMENT category of functions.
See Also:
Constant Field Values

SOLVE_CATEGORY

public static final java.lang.String SOLVE_CATEGORY
A static constant String for the SOLVE category of functions.
See Also:
Constant Field Values

AGGREGATION_CATEGORY

public static final java.lang.String AGGREGATION_CATEGORY
A static constant String for the AGGREGATION category of functions.
See Also:
Constant Field Values

HIER_PARENT

public static final FunctionDescriptor HIER_PARENT
A static constant FunctionDescriptor representing the function HIER_PARENT.

HIER_CHILD_COUNT

public static final FunctionDescriptor HIER_CHILD_COUNT
A static constant FunctionDescriptor representing the function HIER_CHILD_COUNT.

HIER_DEPTH

public static final FunctionDescriptor HIER_DEPTH
A static constant FunctionDescriptor representing the function HIER_DEPTH.

HIER_TOP

public static final FunctionDescriptor HIER_TOP
A static constant FunctionDescriptor representing the function HIER_TOP.

HIER_ORDER

public static final FunctionDescriptor HIER_ORDER
A static constant FunctionDescriptor representing the function HIER_ORDER.

HIER_HAS_CHILDREN

public static final FunctionDescriptor HIER_HAS_CHILDREN
A static constant FunctionDescriptor representing the function HIER_HAS_CHILDREN.

HIER_LEVEL

public static final FunctionDescriptor HIER_LEVEL
A static constant FunctionDescriptor representing the function HIER_LEVEL.

HIER_ANCESTOR

public static final FunctionDescriptor HIER_ANCESTOR
A static constant FunctionDescriptor representing the function HIER_ANCESTOR.

HIER_ANCESTORS

public static final FunctionDescriptor HIER_ANCESTORS
A static constant FunctionDescriptor representing the function HIER_ANCESTORS.

HIER_DESCENDANTS

public static final FunctionDescriptor HIER_DESCENDANTS
A static constant FunctionDescriptor representing the function HIER_DESCENDANTS.

HIER_LEAF_DESCENDANTS

public static final FunctionDescriptor HIER_LEAF_DESCENDANTS
A static constant FunctionDescriptor representing the function HIER_LEAF_DESCENDANTS.

HIER_CHILDREN

public static final FunctionDescriptor HIER_CHILDREN
A static constant FunctionDescriptor representing the function HIER_CHILDREN.

HIER_SIBLINGS

public static final FunctionDescriptor HIER_SIBLINGS
A static constant FunctionDescriptor representing the function HIER_SIBLINGS.

SHARE

public static final FunctionDescriptor SHARE
A static constant FunctionDescriptor representing the function SHARE.

LAG

public static final FunctionDescriptor LAG
A static constant FunctionDescriptor representing the function LAG.

LAG_VARIANCE_PERCENT

public static final FunctionDescriptor LAG_VARIANCE_PERCENT
A static constant FunctionDescriptor representing the function LAG_VARIANCE_PERCENT.

LAG_VARIANCE

public static final FunctionDescriptor LAG_VARIANCE
A static constant FunctionDescriptor representing the function LAG_VARIANCE.

LEAD

public static final FunctionDescriptor LEAD
A static constant FunctionDescriptor representing the function LEAD.

LEAD_VARIANCE_PERCENT

public static final FunctionDescriptor LEAD_VARIANCE_PERCENT
A static constant FunctionDescriptor representing the function LEAD_VARIANCE_PERCENT.

LEAD_VARIANCE

public static final FunctionDescriptor LEAD_VARIANCE
A static constant FunctionDescriptor representing the function LEAD_VARIANCE.

OLAP_SUM

public static final FunctionDescriptor OLAP_SUM
A static constant FunctionDescriptor representing the function SUM.

OLAP_AVG

public static final FunctionDescriptor OLAP_AVG
A static constant FunctionDescriptor representing the function AVG.

OLAP_MAX

public static final FunctionDescriptor OLAP_MAX
A static constant FunctionDescriptor representing the function MAX.

OLAP_MIN

public static final FunctionDescriptor OLAP_MIN
A static constant FunctionDescriptor representing the function MIN.

OLAP_COUNT

public static final FunctionDescriptor OLAP_COUNT
A static constant FunctionDescriptor representing the function COUNT.

RANK

public static final FunctionDescriptor RANK
A static constant FunctionDescriptor representing the function RANK.

DENSE_RANK

public static final FunctionDescriptor DENSE_RANK
A static constant FunctionDescriptor representing the function DENSE_RANK.

AVERAGE_RANK

public static final FunctionDescriptor AVERAGE_RANK
A static constant FunctionDescriptor representing the function AVERAGE_RANK.

ROW_NUMBER

public static final FunctionDescriptor ROW_NUMBER
A static constant FunctionDescriptor representing the function ROW_NUMBER.

ABS

public static final FunctionDescriptor ABS
A static constant FunctionDescriptor representing the function ABS.

ACOS

public static final FunctionDescriptor ACOS
A static constant FunctionDescriptor representing the function ACOS.

ASIN

public static final FunctionDescriptor ASIN
A static constant FunctionDescriptor representing the function ASIN.

ATAN

public static final FunctionDescriptor ATAN
A static constant FunctionDescriptor representing the function ATAN.

ATAN2

public static final FunctionDescriptor ATAN2
A static constant FunctionDescriptor representing the function ATAN2.

BITAND

public static final FunctionDescriptor BITAND
A static constant FunctionDescriptor representing the function BITAND.

CEIL

public static final FunctionDescriptor CEIL
A static constant FunctionDescriptor representing the function CEIL.

COS

public static final FunctionDescriptor COS
A static constant FunctionDescriptor representing the function COS.

COSH

public static final FunctionDescriptor COSH
A static constant FunctionDescriptor representing the function COSH.

EXP

public static final FunctionDescriptor EXP
A static constant FunctionDescriptor representing the function EXP.

FLOOR

public static final FunctionDescriptor FLOOR
A static constant FunctionDescriptor representing the function FLOOR.

LN

public static final FunctionDescriptor LN
A static constant FunctionDescriptor representing the function LN.

LOG

public static final FunctionDescriptor LOG
A static constant FunctionDescriptor representing the function LOG.

MOD

public static final FunctionDescriptor MOD
A static constant FunctionDescriptor representing the function MOD.

NANVL

public static final FunctionDescriptor NANVL
A static constant FunctionDescriptor representing the function NANVL.

POWER

public static final FunctionDescriptor POWER
A static constant FunctionDescriptor representing the function POWER.

REMAINDER

public static final FunctionDescriptor REMAINDER
A static constant FunctionDescriptor representing the function REMAINDER.

ROUND_NUMBER

public static final FunctionDescriptor ROUND_NUMBER
A static constant FunctionDescriptor representing the function ROUND.

SIGN

public static final FunctionDescriptor SIGN
A static constant FunctionDescriptor representing the function SIGN.

SIN

public static final FunctionDescriptor SIN
A static constant FunctionDescriptor representing the function SIN.

SINH

public static final FunctionDescriptor SINH
A static constant FunctionDescriptor representing the function SINH.

SQRT

public static final FunctionDescriptor SQRT
A static constant FunctionDescriptor representing the function SQRT.

TAN

public static final FunctionDescriptor TAN
A static constant FunctionDescriptor representing the function TAN.

TANH

public static final FunctionDescriptor TANH
A static constant FunctionDescriptor representing the function TANH.

TRUNC

public static final FunctionDescriptor TRUNC
A static constant FunctionDescriptor representing the function TRUNC.

WIDTH_BUCKET

public static final FunctionDescriptor WIDTH_BUCKET
A static constant FunctionDescriptor representing the function WIDTH_BUCKET.

ASCII

public static final FunctionDescriptor ASCII
A static constant FunctionDescriptor representing the function ASCII.

CHR

public static final FunctionDescriptor CHR
A static constant FunctionDescriptor representing the function CHR.

CONCAT

public static final FunctionDescriptor CONCAT
A static constant FunctionDescriptor representing the function CONCAT.

INITCAP

public static final FunctionDescriptor INITCAP
A static constant FunctionDescriptor representing the function INITCAP.

INSTR

public static final FunctionDescriptor INSTR
A static constant FunctionDescriptor representing the function INSTR.

INSTRB

public static final FunctionDescriptor INSTRB
A static constant FunctionDescriptor representing the function INSTRB.

INSTRC

public static final FunctionDescriptor INSTRC
A static constant FunctionDescriptor representing the function INSTRC.

INSTR2

public static final FunctionDescriptor INSTR2
A static constant FunctionDescriptor representing the function INSTR2.

INSTR4

public static final FunctionDescriptor INSTR4
A static constant FunctionDescriptor representing the function INSTR4.

LENGTH

public static final FunctionDescriptor LENGTH
A static constant FunctionDescriptor representing the function LENGTH.

LENGTHB

public static final FunctionDescriptor LENGTHB
A static constant FunctionDescriptor representing the function LENGTHB.

LENGTHC

public static final FunctionDescriptor LENGTHC
A static constant FunctionDescriptor representing the function LENGTHC.

LENGTH2

public static final FunctionDescriptor LENGTH2
A static constant FunctionDescriptor representing the function LENGTH2.

LENGTH4

public static final FunctionDescriptor LENGTH4
A static constant FunctionDescriptor representing the function LENGTH4.

LOWER

public static final FunctionDescriptor LOWER
A static constant FunctionDescriptor representing the function LOWER.

UPPER

public static final FunctionDescriptor UPPER
A static constant FunctionDescriptor representing the function UPPER.

LPAD

public static final FunctionDescriptor LPAD
A static constant FunctionDescriptor representing the function LPAD.

RPAD

public static final FunctionDescriptor RPAD
A static constant FunctionDescriptor representing the function RPAD.

LTRIM

public static final FunctionDescriptor LTRIM
A static constant FunctionDescriptor representing the function LTRIM.

RTRIM

public static final FunctionDescriptor RTRIM
A static constant FunctionDescriptor representing the function RTRIM.

NLS_INITCAP

public static final FunctionDescriptor NLS_INITCAP
A static constant FunctionDescriptor representing the function NLS_INITCAP.

NLSSORT

public static final FunctionDescriptor NLSSORT
A static constant FunctionDescriptor representing the function NLSSORT.

NLS_LOWER

public static final FunctionDescriptor NLS_LOWER
A static constant FunctionDescriptor representing the function NLS_LOWER.

NLS_UPPER

public static final FunctionDescriptor NLS_UPPER
A static constant FunctionDescriptor representing the function NLS_UPPER.

REGEXP_INSTR

public static final FunctionDescriptor REGEXP_INSTR
A static constant FunctionDescriptor representing the function REGEXP_INSTR.

REGEXP_COUNT

public static final FunctionDescriptor REGEXP_COUNT
A static constant FunctionDescriptor representing the function REGEXP_COUNT.

REGEXP_REPLACE

public static final FunctionDescriptor REGEXP_REPLACE
A static constant FunctionDescriptor representing the function REGEXP_REPLACE.

REGEXP_SUBSTR

public static final FunctionDescriptor REGEXP_SUBSTR
A static constant FunctionDescriptor representing the function REGEXP_SUBSTR.

REPLACE

public static final FunctionDescriptor REPLACE
A static constant FunctionDescriptor representing the function REPLACE.

SOUNDEX

public static final FunctionDescriptor SOUNDEX
A static constant FunctionDescriptor representing the function SOUNDEX.

SUBSTR

public static final FunctionDescriptor SUBSTR
A static constant FunctionDescriptor representing the function SUBSTR.

SUBSTRB

public static final FunctionDescriptor SUBSTRB
A static constant FunctionDescriptor representing the function SUBSTRB.

SUBSTRC

public static final FunctionDescriptor SUBSTRC
A static constant FunctionDescriptor representing the function SUBSTRC.

SUBSTR2

public static final FunctionDescriptor SUBSTR2
A static constant FunctionDescriptor representing the function SUBSTR2.

SUBSTR4

public static final FunctionDescriptor SUBSTR4
A static constant FunctionDescriptor representing the function SUBSTR4.

TRANSLATE

public static final FunctionDescriptor TRANSLATE
A static constant FunctionDescriptor representing the function TRANSLATE.

TREAT

public static final FunctionDescriptor TREAT
A static constant FunctionDescriptor representing the function TREAT.

TRIM

public static final FunctionDescriptor TRIM
A static constant FunctionDescriptor representing the function TRIM.

NLS_CHARSET_DECL_LEN

public static final FunctionDescriptor NLS_CHARSET_DECL_LEN
A static constant FunctionDescriptor representing the function NLS_CHARSET_DECL_LEN.

NLS_CHARSET_ID

public static final FunctionDescriptor NLS_CHARSET_ID
A static constant FunctionDescriptor representing the function NLS_CHARSET_ID.

NLS_CHARSET_NAME

public static final FunctionDescriptor NLS_CHARSET_NAME
A static constant FunctionDescriptor representing the function NLS_CHARSET_NAME.

ADD_MONTHS

public static final FunctionDescriptor ADD_MONTHS
A static constant FunctionDescriptor representing the function ADD_MONTHS.

CURRENT_DATE

public static final FunctionDescriptor CURRENT_DATE
A static constant FunctionDescriptor representing the function CURRENT_DATE.

CURRENT_TIMESTAMP

public static final FunctionDescriptor CURRENT_TIMESTAMP
A static constant FunctionDescriptor representing the function CURRENT_TIMESTAMP.

DBTIMEZONE

public static final FunctionDescriptor DBTIMEZONE
A static constant FunctionDescriptor representing the function DBTIMEZONE.

EXTRACT_DATE

public static final FunctionDescriptor EXTRACT_DATE
A static constant FunctionDescriptor representing the function EXTRACT.

FROM_TZ

public static final FunctionDescriptor FROM_TZ
A static constant FunctionDescriptor representing the function FROM_TZ.

LAST_DAY

public static final FunctionDescriptor LAST_DAY
A static constant FunctionDescriptor representing the function LAST_DAY.

LOCALTIMESTAMP

public static final FunctionDescriptor LOCALTIMESTAMP
A static constant FunctionDescriptor representing the function LOCALTIMESTAMP.

MONTHS_BETWEEN

public static final FunctionDescriptor MONTHS_BETWEEN
A static constant FunctionDescriptor representing the function MONTHS_BETWEEN.

NEW_TIME

public static final FunctionDescriptor NEW_TIME
A static constant FunctionDescriptor representing the function NEW_TIME.

NEXT_DAY

public static final FunctionDescriptor NEXT_DAY
A static constant FunctionDescriptor representing the function NEXT_DAY.

ROUND_DATE

public static final FunctionDescriptor ROUND_DATE
A static constant FunctionDescriptor representing the function ROUND.

SESSIONTIMEZONE

public static final FunctionDescriptor SESSIONTIMEZONE
A static constant FunctionDescriptor representing the function SESSIONTIMEZONE.

SYS_EXTRACT_UTC

public static final FunctionDescriptor SYS_EXTRACT_UTC
A static constant FunctionDescriptor representing the function SYS_EXTRACT_UTC.

SYSDATE

public static final FunctionDescriptor SYSDATE
A static constant FunctionDescriptor representing the function SYSDATE.

SYSTIMESTAMP

public static final FunctionDescriptor SYSTIMESTAMP
A static constant FunctionDescriptor representing the function SYSTIMESTAMP.

TO_DSINTERVAL

public static final FunctionDescriptor TO_DSINTERVAL
A static constant FunctionDescriptor representing the function TO_DSINTERVAL.

TO_TIMESTAMP

public static final FunctionDescriptor TO_TIMESTAMP
A static constant FunctionDescriptor representing the function TO_TIMESTAMP.

TO_TIMESTAMP_TZ

public static final FunctionDescriptor TO_TIMESTAMP_TZ
A static constant FunctionDescriptor representing the function TO_TIMESTAMP_TZ.

TO_YMINTERVAL

public static final FunctionDescriptor TO_YMINTERVAL
A static constant FunctionDescriptor representing the function TO_YMINTERVAL.

TZ_OFFSET

public static final FunctionDescriptor TZ_OFFSET
A static constant FunctionDescriptor representing the function TZ_OFFSET.

GREATEST

public static final FunctionDescriptor GREATEST
A static constant FunctionDescriptor representing the function GREATEST.

LEAST

public static final FunctionDescriptor LEAST
A static constant FunctionDescriptor representing the function LEAST.

ASCIISTR

public static final FunctionDescriptor ASCIISTR
A static constant FunctionDescriptor representing the function ASCIISTR.

BIN_TO_NUM

public static final FunctionDescriptor BIN_TO_NUM
A static constant FunctionDescriptor representing the function BIN_TO_NUM.

CAST

public static final FunctionDescriptor CAST
A static constant FunctionDescriptor representing the function CAST.

CHARTOROWID

public static final FunctionDescriptor CHARTOROWID
A static constant FunctionDescriptor representing the function CHARTOROWID.

COMPOSE

public static final FunctionDescriptor COMPOSE
A static constant FunctionDescriptor representing the function COMPOSE.

CONVERT

public static final FunctionDescriptor CONVERT
A static constant FunctionDescriptor representing the function CONVERT.

DECOMPOSE

public static final FunctionDescriptor DECOMPOSE
A static constant FunctionDescriptor representing the function DECOMPOSE.

HEXTORAW

public static final FunctionDescriptor HEXTORAW
A static constant FunctionDescriptor representing the function HEXTORAW.

NUMTODSINTERVAL

public static final FunctionDescriptor NUMTODSINTERVAL
A static constant FunctionDescriptor representing the function NUMTODSINTERVAL.

NUMTOYMINTERVAL

public static final FunctionDescriptor NUMTOYMINTERVAL
A static constant FunctionDescriptor representing the function NUMTOYMINTERVAL.

RAWTOHEX

public static final FunctionDescriptor RAWTOHEX
A static constant FunctionDescriptor representing the function RAWTOHEX.

RAWTONHEX

public static final FunctionDescriptor RAWTONHEX
A static constant FunctionDescriptor representing the function RAWTONHEX.

ROWIDTOCHAR

public static final FunctionDescriptor ROWIDTOCHAR
A static constant FunctionDescriptor representing the function ROWIDTOCHAR.

ROWIDTONCHAR

public static final FunctionDescriptor ROWIDTONCHAR
A static constant FunctionDescriptor representing the function ROWIDTONCHAR.

SCN_TO_TIMESTAMP

public static final FunctionDescriptor SCN_TO_TIMESTAMP
A static constant FunctionDescriptor representing the function SCN_TO_TIMESTAMP.

TIMESTAMP_TO_SCN

public static final FunctionDescriptor TIMESTAMP_TO_SCN
A static constant FunctionDescriptor representing the function TIMESTAMP_TO_SCN.

TO_BINARY_DOUBLE

public static final FunctionDescriptor TO_BINARY_DOUBLE
A static constant FunctionDescriptor representing the function TO_BINARY_DOUBLE.

TO_BINARY_FLOAT

public static final FunctionDescriptor TO_BINARY_FLOAT
A static constant FunctionDescriptor representing the function TO_BINARY_FLOAT.

CHAR_TO_CHAR

public static final FunctionDescriptor CHAR_TO_CHAR
A static constant FunctionDescriptor representing the function TO_CHAR.

NUMBER_TO_CHAR

public static final FunctionDescriptor NUMBER_TO_CHAR
A static constant FunctionDescriptor representing the function TO_CHAR.

DATETIME_TO_CHAR

public static final FunctionDescriptor DATETIME_TO_CHAR
A static constant FunctionDescriptor representing the function TO_CHAR.

INTERVAL_TO_CHAR

public static final FunctionDescriptor INTERVAL_TO_CHAR
A static constant FunctionDescriptor representing the function TO_CHAR.

TO_CLOB

public static final FunctionDescriptor TO_CLOB
A static constant FunctionDescriptor representing the function TO_CLOB.

TO_DATE

public static final FunctionDescriptor TO_DATE
A static constant FunctionDescriptor representing the function TO_DATE.

TO_LOB

public static final FunctionDescriptor TO_LOB
A static constant FunctionDescriptor representing the function TO_LOB.

TO_MULTI_BYTE

public static final FunctionDescriptor TO_MULTI_BYTE
A static constant FunctionDescriptor representing the function TO_MULTI_BYTE.

CHAR_TO_NCHAR

public static final FunctionDescriptor CHAR_TO_NCHAR
A static constant FunctionDescriptor representing the function TO_NCHAR.

NUMBER_TO_NCHAR

public static final FunctionDescriptor NUMBER_TO_NCHAR
A static constant FunctionDescriptor representing the function TO_NCHAR.

DATETIME_TO_NCHAR

public static final FunctionDescriptor DATETIME_TO_NCHAR
A static constant FunctionDescriptor representing the function TO_NCHAR.

INTERVAL_TO_NCHAR

public static final FunctionDescriptor INTERVAL_TO_NCHAR
A static constant FunctionDescriptor representing the function TO_NCHAR.

TO_NCLOB

public static final FunctionDescriptor TO_NCLOB
A static constant FunctionDescriptor representing the function TO_NCLOB.

TO_NUMBER

public static final FunctionDescriptor TO_NUMBER
A static constant FunctionDescriptor representing the function TO_NUMBER.

TO_SINGLE_BYTE

public static final FunctionDescriptor TO_SINGLE_BYTE
A static constant FunctionDescriptor representing the function TO_SINGLE_BYTE.

TRANSLATE_USING

public static final FunctionDescriptor TRANSLATE_USING
A static constant FunctionDescriptor representing the function TRANSLATE.

UNISTR

public static final FunctionDescriptor UNISTR
A static constant FunctionDescriptor representing the function UNISTR.

DECODE

public static final FunctionDescriptor DECODE
A static constant FunctionDescriptor representing the function DECODE.

ORA_HASH

public static final FunctionDescriptor ORA_HASH
A static constant FunctionDescriptor representing the function ORA_HASH.

DUMP

public static final FunctionDescriptor DUMP
A static constant FunctionDescriptor representing the function DUMP.

VSIZE

public static final FunctionDescriptor VSIZE
A static constant FunctionDescriptor representing the function VSIZE.

COALESCE

public static final FunctionDescriptor COALESCE
A static constant FunctionDescriptor representing the function COALESCE.

NULLIF

public static final FunctionDescriptor NULLIF
A static constant FunctionDescriptor representing the function NULLIF.

NVL

public static final FunctionDescriptor NVL
A static constant FunctionDescriptor representing the function NVL.

NVL2

public static final FunctionDescriptor NVL2
A static constant FunctionDescriptor representing the function NVL2.

LNNVL

public static final FunctionDescriptor LNNVL
A static constant FunctionDescriptor representing the function LNNVL.

SYS_CONTEXT

public static final FunctionDescriptor SYS_CONTEXT
A static constant FunctionDescriptor representing the function SYS_CONTEXT.

SYS_GUID

public static final FunctionDescriptor SYS_GUID
A static constant FunctionDescriptor representing the function SYS_GUID.

UID

public static final FunctionDescriptor UID
A static constant FunctionDescriptor representing the function UID.

USER

public static final FunctionDescriptor USER
A static constant FunctionDescriptor representing the function USER.

SYS_TYPEID

public static final FunctionDescriptor SYS_TYPEID
A static constant FunctionDescriptor representing the function SYS_TYPEID.

USERENV

public static final FunctionDescriptor USERENV
A static constant FunctionDescriptor representing the function USERENV.

AGGREGATION_SUM

public static final FunctionDescriptor AGGREGATION_SUM
A static constant FunctionDescriptor representing the function SUM.

AGGREGATION_AVG

public static final FunctionDescriptor AGGREGATION_AVG
A static constant FunctionDescriptor representing the function AVG.

HIER_AVG

public static final FunctionDescriptor HIER_AVG
A static constant FunctionDescriptor representing the function HIER_AVG.

AGGREGATION_FIRST

public static final FunctionDescriptor AGGREGATION_FIRST
A static constant FunctionDescriptor representing the function FIRST.

AGGREGATION_LAST

public static final FunctionDescriptor AGGREGATION_LAST
A static constant FunctionDescriptor representing the function LAST.

HIER_FIRST

public static final FunctionDescriptor HIER_FIRST
A static constant FunctionDescriptor representing the function HIER_FIRST.

HIER_LAST

public static final FunctionDescriptor HIER_LAST
A static constant FunctionDescriptor representing the function HIER_LAST.

AGGREGATION_MAX

public static final FunctionDescriptor AGGREGATION_MAX
A static constant FunctionDescriptor representing the function MAX.

AGGREGATION_MIN

public static final FunctionDescriptor AGGREGATION_MIN
A static constant FunctionDescriptor representing the function MIN.

AGGREGATE

public static final FunctionDescriptor AGGREGATE
A static constant FunctionDescriptor representing the function AGGREGATE.

Skip navigation links

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