|
Oracle® OLAP Java API Reference 12c Release 1 (12.1) E17708-05 |
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Object
oracle.olapi.syntax.FunctionDescriptorCatalog
public final class FunctionDescriptorCatalog
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 |
ABSA static constant FunctionDescriptor representing the function ABS. |
static FunctionDescriptor |
ACOSA static constant FunctionDescriptor representing the function ACOS. |
static FunctionDescriptor |
ADD_MONTHSA static constant FunctionDescriptor representing the function ADD_MONTHS. |
static FunctionDescriptor |
AGGREGATEA static constant FunctionDescriptor representing the function AGGREGATE. |
static FunctionDescriptor |
AGGREGATION_AVGA static constant FunctionDescriptor representing the function AVG. |
static java.lang.String |
AGGREGATION_CATEGORYA static constant String for the AGGREGATION category of functions. |
static FunctionDescriptor |
AGGREGATION_FIRSTA static constant FunctionDescriptor representing the function FIRST. |
static FunctionDescriptor |
AGGREGATION_LASTA static constant FunctionDescriptor representing the function LAST. |
static FunctionDescriptor |
AGGREGATION_MAXA static constant FunctionDescriptor representing the function MAX. |
static FunctionDescriptor |
AGGREGATION_MINA static constant FunctionDescriptor representing the function MIN. |
static FunctionDescriptor |
AGGREGATION_SUMA static constant FunctionDescriptor representing the function SUM. |
static FunctionDescriptor |
ASCIIA static constant FunctionDescriptor representing the function ASCII. |
static FunctionDescriptor |
ASCIISTRA static constant FunctionDescriptor representing the function ASCIISTR. |
static FunctionDescriptor |
ASINA static constant FunctionDescriptor representing the function ASIN. |
static FunctionDescriptor |
ATANA static constant FunctionDescriptor representing the function ATAN. |
static FunctionDescriptor |
ATAN2A static constant FunctionDescriptor representing the function ATAN2. |
static FunctionDescriptor |
AVERAGE_RANKA static constant FunctionDescriptor representing the function AVERAGE_RANK. |
static FunctionDescriptor |
BIN_TO_NUMA static constant FunctionDescriptor representing the function BIN_TO_NUM. |
static FunctionDescriptor |
BITANDA static constant FunctionDescriptor representing the function BITAND. |
static FunctionDescriptor |
CASTA static constant FunctionDescriptor representing the function CAST. |
static FunctionDescriptor |
CEILA static constant FunctionDescriptor representing the function CEIL. |
static FunctionDescriptor |
CHAR_TO_CHARA static constant FunctionDescriptor representing the function TO_CHAR. |
static FunctionDescriptor |
CHAR_TO_NCHARA static constant FunctionDescriptor representing the function TO_NCHAR. |
static java.lang.String |
CHARACTER_CATEGORYA static constant String for the CHARACTER category of functions. |
static FunctionDescriptor |
CHARTOROWIDA static constant FunctionDescriptor representing the function CHARTOROWID. |
static FunctionDescriptor |
CHRA static constant FunctionDescriptor representing the function CHR. |
static FunctionDescriptor |
COALESCEA static constant FunctionDescriptor representing the function COALESCE. |
static java.lang.String |
COMPARISON_CATEGORYA static constant String for the COMPARISON category of functions. |
static FunctionDescriptor |
COMPOSEA static constant FunctionDescriptor representing the function COMPOSE. |
static FunctionDescriptor |
CONCATA static constant FunctionDescriptor representing the function CONCAT. |
static java.lang.String |
CONVERSION_CATEGORYA static constant String for the CONVERSION category of functions. |
static FunctionDescriptor |
CONVERTA static constant FunctionDescriptor representing the function CONVERT. |
static FunctionDescriptor |
COSA static constant FunctionDescriptor representing the function COS. |
static FunctionDescriptor |
COSHA static constant FunctionDescriptor representing the function COSH. |
static FunctionDescriptor |
CURRENT_DATEA static constant FunctionDescriptor representing the function CURRENT_DATE. |
static FunctionDescriptor |
CURRENT_TIMESTAMPA static constant FunctionDescriptor representing the function CURRENT_TIMESTAMP. |
static java.lang.String |
DATETIME_CATEGORYA static constant String for the DATETIME category of functions. |
static FunctionDescriptor |
DATETIME_TO_CHARA static constant FunctionDescriptor representing the function TO_CHAR. |
static FunctionDescriptor |
DATETIME_TO_NCHARA static constant FunctionDescriptor representing the function TO_NCHAR. |
static FunctionDescriptor |
DBTIMEZONEA static constant FunctionDescriptor representing the function DBTIMEZONE. |
static FunctionDescriptor |
DECODEA static constant FunctionDescriptor representing the function DECODE. |
static FunctionDescriptor |
DECOMPOSEA static constant FunctionDescriptor representing the function DECOMPOSE. |
static FunctionDescriptor |
DENSE_RANKA static constant FunctionDescriptor representing the function DENSE_RANK. |
static FunctionDescriptor |
DUMPA static constant FunctionDescriptor representing the function DUMP. |
static java.lang.String |
ENCODING_CATEGORYA static constant String for the ENCODING category of functions. |
static java.lang.String |
ENVIRONMENT_CATEGORYA static constant String for the ENVIRONMENT category of functions. |
static FunctionDescriptor |
EXPA static constant FunctionDescriptor representing the function EXP. |
static FunctionDescriptor |
EXTRACT_DATEA static constant FunctionDescriptor representing the function EXTRACT. |
static FunctionDescriptor |
FLOORA static constant FunctionDescriptor representing the function FLOOR. |
static FunctionDescriptor |
FROM_TZA static constant FunctionDescriptor representing the function FROM_TZ. |
static FunctionDescriptor |
GREATESTA static constant FunctionDescriptor representing the function GREATEST. |
static FunctionDescriptor |
HEXTORAWA static constant FunctionDescriptor representing the function HEXTORAW. |
static FunctionDescriptor |
HIER_ANCESTORA static constant FunctionDescriptor representing the function HIER_ANCESTOR. |
static FunctionDescriptor |
HIER_ANCESTORSA static constant FunctionDescriptor representing the function HIER_ANCESTORS. |
static FunctionDescriptor |
HIER_AVGA static constant FunctionDescriptor representing the function HIER_AVG. |
static FunctionDescriptor |
HIER_CHILD_COUNTA static constant FunctionDescriptor representing the function HIER_CHILD_COUNT. |
static FunctionDescriptor |
HIER_CHILDRENA static constant FunctionDescriptor representing the function HIER_CHILDREN. |
static FunctionDescriptor |
HIER_DEPTHA static constant FunctionDescriptor representing the function HIER_DEPTH. |
static FunctionDescriptor |
HIER_DESCENDANTSA static constant FunctionDescriptor representing the function HIER_DESCENDANTS. |
static FunctionDescriptor |
HIER_FIRSTA static constant FunctionDescriptor representing the function HIER_FIRST. |
static FunctionDescriptor |
HIER_HAS_CHILDRENA static constant FunctionDescriptor representing the function HIER_HAS_CHILDREN. |
static FunctionDescriptor |
HIER_LASTA static constant FunctionDescriptor representing the function HIER_LAST. |
static FunctionDescriptor |
HIER_LEAF_DESCENDANTSA static constant FunctionDescriptor representing the function HIER_LEAF_DESCENDANTS. |
static FunctionDescriptor |
HIER_LEVELA static constant FunctionDescriptor representing the function HIER_LEVEL. |
static FunctionDescriptor |
HIER_ORDERA static constant FunctionDescriptor representing the function HIER_ORDER. |
static FunctionDescriptor |
HIER_PARENTA static constant FunctionDescriptor representing the function HIER_PARENT. |
static FunctionDescriptor |
HIER_SIBLINGSA static constant FunctionDescriptor representing the function HIER_SIBLINGS. |
static FunctionDescriptor |
HIER_TOPA static constant FunctionDescriptor representing the function HIER_TOP. |
static java.lang.String |
HIERARCHICAL_CATEGORYA static constant String for the HIERARCHICAL category of functions. |
static FunctionDescriptor |
INITCAPA static constant FunctionDescriptor representing the function INITCAP. |
static FunctionDescriptor |
INSTRA static constant FunctionDescriptor representing the function INSTR. |
static FunctionDescriptor |
INSTR2A static constant FunctionDescriptor representing the function INSTR2. |
static FunctionDescriptor |
INSTR4A static constant FunctionDescriptor representing the function INSTR4. |
static FunctionDescriptor |
INSTRBA static constant FunctionDescriptor representing the function INSTRB. |
static FunctionDescriptor |
INSTRCA static constant FunctionDescriptor representing the function INSTRC. |
static FunctionDescriptor |
INTERVAL_TO_CHARA static constant FunctionDescriptor representing the function TO_CHAR. |
static FunctionDescriptor |
INTERVAL_TO_NCHARA static constant FunctionDescriptor representing the function TO_NCHAR. |
static FunctionDescriptor |
LAGA static constant FunctionDescriptor representing the function LAG. |
static FunctionDescriptor |
LAG_VARIANCEA static constant FunctionDescriptor representing the function LAG_VARIANCE. |
static FunctionDescriptor |
LAG_VARIANCE_PERCENTA static constant FunctionDescriptor representing the function LAG_VARIANCE_PERCENT. |
static FunctionDescriptor |
LAST_DAYA static constant FunctionDescriptor representing the function LAST_DAY. |
static FunctionDescriptor |
LEADA static constant FunctionDescriptor representing the function LEAD. |
static FunctionDescriptor |
LEAD_VARIANCEA static constant FunctionDescriptor representing the function LEAD_VARIANCE. |
static FunctionDescriptor |
LEAD_VARIANCE_PERCENTA static constant FunctionDescriptor representing the function LEAD_VARIANCE_PERCENT. |
static FunctionDescriptor |
LEASTA static constant FunctionDescriptor representing the function LEAST. |
static FunctionDescriptor |
LENGTHA static constant FunctionDescriptor representing the function LENGTH. |
static FunctionDescriptor |
LENGTH2A static constant FunctionDescriptor representing the function LENGTH2. |
static FunctionDescriptor |
LENGTH4A static constant FunctionDescriptor representing the function LENGTH4. |
static FunctionDescriptor |
LENGTHBA static constant FunctionDescriptor representing the function LENGTHB. |
static FunctionDescriptor |
LENGTHCA static constant FunctionDescriptor representing the function LENGTHC. |
static FunctionDescriptor |
LNA static constant FunctionDescriptor representing the function LN. |
static FunctionDescriptor |
LNNVLA static constant FunctionDescriptor representing the function LNNVL. |
static FunctionDescriptor |
LOCALTIMESTAMPA static constant FunctionDescriptor representing the function LOCALTIMESTAMP. |
static FunctionDescriptor |
LOGA static constant FunctionDescriptor representing the function LOG. |
static FunctionDescriptor |
LOWERA static constant FunctionDescriptor representing the function LOWER. |
static FunctionDescriptor |
LPADA static constant FunctionDescriptor representing the function LPAD. |
static FunctionDescriptor |
LTRIMA static constant FunctionDescriptor representing the function LTRIM. |
static FunctionDescriptor |
MODA static constant FunctionDescriptor representing the function MOD. |
static FunctionDescriptor |
MONTHS_BETWEENA static constant FunctionDescriptor representing the function MONTHS_BETWEEN. |
static FunctionDescriptor |
NANVLA static constant FunctionDescriptor representing the function NANVL. |
static FunctionDescriptor |
NEW_TIMEA static constant FunctionDescriptor representing the function NEW_TIME. |
static FunctionDescriptor |
NEXT_DAYA static constant FunctionDescriptor representing the function NEXT_DAY. |
static java.lang.String |
NLS_CATEGORYA static constant String for the NLS category of functions. |
static FunctionDescriptor |
NLS_CHARSET_DECL_LENA static constant FunctionDescriptor representing the function NLS_CHARSET_DECL_LEN. |
static FunctionDescriptor |
NLS_CHARSET_IDA static constant FunctionDescriptor representing the function NLS_CHARSET_ID. |
static FunctionDescriptor |
NLS_CHARSET_NAMEA static constant FunctionDescriptor representing the function NLS_CHARSET_NAME. |
static FunctionDescriptor |
NLS_INITCAPA static constant FunctionDescriptor representing the function NLS_INITCAP. |
static FunctionDescriptor |
NLS_LOWERA static constant FunctionDescriptor representing the function NLS_LOWER. |
static FunctionDescriptor |
NLS_UPPERA static constant FunctionDescriptor representing the function NLS_UPPER. |
static FunctionDescriptor |
NLSSORTA static constant FunctionDescriptor representing the function NLSSORT. |
static FunctionDescriptor |
NO_AGGREGATEA static constant FunctionDescriptor representing the function NO AGGREGATE. |
static java.lang.String |
NULL_RELATED_CATEGORYA static constant String for the NULL RELATED category of functions. |
static FunctionDescriptor |
NULLIFA static constant FunctionDescriptor representing the function NULLIF. |
static FunctionDescriptor |
NUMBER_TO_CHARA static constant FunctionDescriptor representing the function TO_CHAR. |
static FunctionDescriptor |
NUMBER_TO_NCHARA static constant FunctionDescriptor representing the function TO_NCHAR. |
static java.lang.String |
NUMERIC_CATEGORYA static constant String for the NUMERIC category of functions. |
static FunctionDescriptor |
NUMTODSINTERVALA static constant FunctionDescriptor representing the function NUMTODSINTERVAL. |
static FunctionDescriptor |
NUMTOYMINTERVALA static constant FunctionDescriptor representing the function NUMTOYMINTERVAL. |
static FunctionDescriptor |
NVLA static constant FunctionDescriptor representing the function NVL. |
static FunctionDescriptor |
NVL2A static constant FunctionDescriptor representing the function NVL2. |
static FunctionDescriptor |
OLAP_AVGA static constant FunctionDescriptor representing the function AVG. |
static FunctionDescriptor |
OLAP_COUNTA static constant FunctionDescriptor representing the function COUNT. |
static FunctionDescriptor |
OLAP_MAXA static constant FunctionDescriptor representing the function MAX. |
static FunctionDescriptor |
OLAP_MINA static constant FunctionDescriptor representing the function MIN. |
static FunctionDescriptor |
OLAP_SUMA static constant FunctionDescriptor representing the function SUM. |
static FunctionDescriptor |
ORA_HASHA static constant FunctionDescriptor representing the function ORA_HASH. |
static FunctionDescriptor |
POWERA static constant FunctionDescriptor representing the function POWER. |
static FunctionDescriptor |
RANKA static constant FunctionDescriptor representing the function RANK. |
static FunctionDescriptor |
RAWTOHEXA static constant FunctionDescriptor representing the function RAWTOHEX. |
static FunctionDescriptor |
RAWTONHEXA static constant FunctionDescriptor representing the function RAWTONHEX. |
static FunctionDescriptor |
REGEXP_COUNTA static constant FunctionDescriptor representing the function REGEXP_COUNT. |
static FunctionDescriptor |
REGEXP_INSTRA static constant FunctionDescriptor representing the function REGEXP_INSTR. |
static FunctionDescriptor |
REGEXP_REPLACEA static constant FunctionDescriptor representing the function REGEXP_REPLACE. |
static FunctionDescriptor |
REGEXP_SUBSTRA static constant FunctionDescriptor representing the function REGEXP_SUBSTR. |
static FunctionDescriptor |
REMAINDERA static constant FunctionDescriptor representing the function REMAINDER. |
static FunctionDescriptor |
REPLACEA static constant FunctionDescriptor representing the function REPLACE. |
static FunctionDescriptor |
ROUND_DATEA static constant FunctionDescriptor representing the function ROUND. |
static FunctionDescriptor |
ROUND_NUMBERA static constant FunctionDescriptor representing the function ROUND. |
static FunctionDescriptor |
ROW_NUMBERA static constant FunctionDescriptor representing the function ROW_NUMBER. |
static FunctionDescriptor |
ROWIDTOCHARA static constant FunctionDescriptor representing the function ROWIDTOCHAR. |
static FunctionDescriptor |
ROWIDTONCHARA static constant FunctionDescriptor representing the function ROWIDTONCHAR. |
static FunctionDescriptor |
RPADA static constant FunctionDescriptor representing the function RPAD. |
static FunctionDescriptor |
RTRIMA static constant FunctionDescriptor representing the function RTRIM. |
static FunctionDescriptor |
SCN_TO_TIMESTAMPA static constant FunctionDescriptor representing the function SCN_TO_TIMESTAMP. |
static FunctionDescriptor |
SESSIONTIMEZONEA static constant FunctionDescriptor representing the function SESSIONTIMEZONE. |
static FunctionDescriptor |
SHAREA static constant FunctionDescriptor representing the function SHARE. |
static FunctionDescriptor |
SIGNA static constant FunctionDescriptor representing the function SIGN. |
static FunctionDescriptor |
SINA static constant FunctionDescriptor representing the function SIN. |
static FunctionDescriptor |
SINHA static constant FunctionDescriptor representing the function SINH. |
static java.lang.String |
SOLVE_CATEGORYA static constant String for the SOLVE category of functions. |
static FunctionDescriptor |
SOUNDEXA static constant FunctionDescriptor representing the function SOUNDEX. |
static FunctionDescriptor |
SQRTA static constant FunctionDescriptor representing the function SQRT. |
static FunctionDescriptor |
SUBSTRA static constant FunctionDescriptor representing the function SUBSTR. |
static FunctionDescriptor |
SUBSTR2A static constant FunctionDescriptor representing the function SUBSTR2. |
static FunctionDescriptor |
SUBSTR4A static constant FunctionDescriptor representing the function SUBSTR4. |
static FunctionDescriptor |
SUBSTRBA static constant FunctionDescriptor representing the function SUBSTRB. |
static FunctionDescriptor |
SUBSTRCA static constant FunctionDescriptor representing the function SUBSTRC. |
static FunctionDescriptor |
SYS_CONTEXTA static constant FunctionDescriptor representing the function SYS_CONTEXT. |
static FunctionDescriptor |
SYS_EXTRACT_UTCA static constant FunctionDescriptor representing the function SYS_EXTRACT_UTC. |
static FunctionDescriptor |
SYS_GUIDA static constant FunctionDescriptor representing the function SYS_GUID. |
static FunctionDescriptor |
SYS_TYPEIDA static constant FunctionDescriptor representing the function SYS_TYPEID. |
static FunctionDescriptor |
SYSDATEA static constant FunctionDescriptor representing the function SYSDATE. |
static FunctionDescriptor |
SYSTIMESTAMPA static constant FunctionDescriptor representing the function SYSTIMESTAMP. |
static FunctionDescriptor |
TANA static constant FunctionDescriptor representing the function TAN. |
static FunctionDescriptor |
TANHA static constant FunctionDescriptor representing the function TANH. |
static FunctionDescriptor |
TIMESTAMP_TO_SCNA static constant FunctionDescriptor representing the function TIMESTAMP_TO_SCN. |
static FunctionDescriptor |
TO_BINARY_DOUBLEA static constant FunctionDescriptor representing the function TO_BINARY_DOUBLE. |
static FunctionDescriptor |
TO_BINARY_FLOATA static constant FunctionDescriptor representing the function TO_BINARY_FLOAT. |
static FunctionDescriptor |
TO_CLOBA static constant FunctionDescriptor representing the function TO_CLOB. |
static FunctionDescriptor |
TO_DATEA static constant FunctionDescriptor representing the function TO_DATE. |
static FunctionDescriptor |
TO_DSINTERVALA static constant FunctionDescriptor representing the function TO_DSINTERVAL. |
static FunctionDescriptor |
TO_LOBA static constant FunctionDescriptor representing the function TO_LOB. |
static FunctionDescriptor |
TO_MULTI_BYTEA static constant FunctionDescriptor representing the function TO_MULTI_BYTE. |
static FunctionDescriptor |
TO_NCLOBA static constant FunctionDescriptor representing the function TO_NCLOB. |
static FunctionDescriptor |
TO_NUMBERA static constant FunctionDescriptor representing the function TO_NUMBER. |
static FunctionDescriptor |
TO_SINGLE_BYTEA static constant FunctionDescriptor representing the function TO_SINGLE_BYTE. |
static FunctionDescriptor |
TO_TIMESTAMPA static constant FunctionDescriptor representing the function TO_TIMESTAMP. |
static FunctionDescriptor |
TO_TIMESTAMP_TZA static constant FunctionDescriptor representing the function TO_TIMESTAMP_TZ. |
static FunctionDescriptor |
TO_YMINTERVALA static constant FunctionDescriptor representing the function TO_YMINTERVAL. |
static FunctionDescriptor |
TRANSLATEA static constant FunctionDescriptor representing the function TRANSLATE. |
static FunctionDescriptor |
TRANSLATE_USINGA static constant FunctionDescriptor representing the function TRANSLATE. |
static FunctionDescriptor |
TREATA static constant FunctionDescriptor representing the function TREAT. |
static FunctionDescriptor |
TRIMA static constant FunctionDescriptor representing the function TRIM. |
static FunctionDescriptor |
TRUNC_DATEA static constant FunctionDescriptor representing the function TRUNC. |
static FunctionDescriptor |
TRUNC_NUMBERA static constant FunctionDescriptor representing the function TRUNC. |
static FunctionDescriptor |
TZ_OFFSETA static constant FunctionDescriptor representing the function TZ_OFFSET. |
static FunctionDescriptor |
UIDA static constant FunctionDescriptor representing the function UID. |
static FunctionDescriptor |
UNISTRA static constant FunctionDescriptor representing the function UNISTR. |
static FunctionDescriptor |
UPPERA static constant FunctionDescriptor representing the function UPPER. |
static FunctionDescriptor |
USERA static constant FunctionDescriptor representing the function USER. |
static FunctionDescriptor |
USERENVA static constant FunctionDescriptor representing the function USERENV. |
static FunctionDescriptor |
VSIZEA static constant FunctionDescriptor representing the function VSIZE. |
static FunctionDescriptor |
WIDTH_BUCKETA static constant FunctionDescriptor representing the function WIDTH_BUCKET. |
static java.lang.String |
WINDOW_CATEGORYA 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 |
|---|
public static final java.lang.String HIERARCHICAL_CATEGORY
String for the HIERARCHICAL category of functions.
public static final java.lang.String WINDOW_CATEGORY
String for the WINDOW category of functions.
public static final java.lang.String NUMERIC_CATEGORY
String for the NUMERIC category of functions.
public static final java.lang.String CHARACTER_CATEGORY
String for the CHARACTER category of functions.
public static final java.lang.String NLS_CATEGORY
String for the NLS category of functions.
public static final java.lang.String DATETIME_CATEGORY
String for the DATETIME category of functions.
public static final java.lang.String COMPARISON_CATEGORY
String for the COMPARISON category of functions.
public static final java.lang.String CONVERSION_CATEGORY
String for the CONVERSION category of functions.
public static final java.lang.String ENCODING_CATEGORY
String for the ENCODING category of functions.
public static final java.lang.String NULL_RELATED_CATEGORY
String for the NULL RELATED category of functions.
public static final java.lang.String ENVIRONMENT_CATEGORY
String for the ENVIRONMENT category of functions.
public static final java.lang.String SOLVE_CATEGORY
String for the SOLVE category of functions.
public static final java.lang.String AGGREGATION_CATEGORY
String for the AGGREGATION category of functions.
public static final FunctionDescriptor HIER_PARENT
FunctionDescriptor representing the function HIER_PARENT.public static final FunctionDescriptor HIER_CHILD_COUNT
FunctionDescriptor representing the function HIER_CHILD_COUNT.public static final FunctionDescriptor HIER_DEPTH
FunctionDescriptor representing the function HIER_DEPTH.public static final FunctionDescriptor HIER_TOP
FunctionDescriptor representing the function HIER_TOP.public static final FunctionDescriptor HIER_ORDER
FunctionDescriptor representing the function HIER_ORDER.public static final FunctionDescriptor HIER_HAS_CHILDREN
FunctionDescriptor representing the function HIER_HAS_CHILDREN.public static final FunctionDescriptor HIER_LEVEL
FunctionDescriptor representing the function HIER_LEVEL.public static final FunctionDescriptor HIER_ANCESTOR
FunctionDescriptor representing the function HIER_ANCESTOR.public static final FunctionDescriptor HIER_ANCESTORS
FunctionDescriptor representing the function HIER_ANCESTORS.public static final FunctionDescriptor HIER_DESCENDANTS
FunctionDescriptor representing the function HIER_DESCENDANTS.public static final FunctionDescriptor HIER_LEAF_DESCENDANTS
FunctionDescriptor representing the function HIER_LEAF_DESCENDANTS.public static final FunctionDescriptor HIER_CHILDREN
FunctionDescriptor representing the function HIER_CHILDREN.public static final FunctionDescriptor HIER_SIBLINGS
FunctionDescriptor representing the function HIER_SIBLINGS.public static final FunctionDescriptor SHARE
FunctionDescriptor representing the function SHARE.public static final FunctionDescriptor LAG
FunctionDescriptor representing the function LAG.public static final FunctionDescriptor LAG_VARIANCE_PERCENT
FunctionDescriptor representing the function LAG_VARIANCE_PERCENT.public static final FunctionDescriptor LAG_VARIANCE
FunctionDescriptor representing the function LAG_VARIANCE.public static final FunctionDescriptor LEAD
FunctionDescriptor representing the function LEAD.public static final FunctionDescriptor LEAD_VARIANCE_PERCENT
FunctionDescriptor representing the function LEAD_VARIANCE_PERCENT.public static final FunctionDescriptor LEAD_VARIANCE
FunctionDescriptor representing the function LEAD_VARIANCE.public static final FunctionDescriptor OLAP_SUM
FunctionDescriptor representing the function SUM.public static final FunctionDescriptor OLAP_AVG
FunctionDescriptor representing the function AVG.public static final FunctionDescriptor OLAP_MAX
FunctionDescriptor representing the function MAX.public static final FunctionDescriptor OLAP_MIN
FunctionDescriptor representing the function MIN.public static final FunctionDescriptor OLAP_COUNT
FunctionDescriptor representing the function COUNT.public static final FunctionDescriptor RANK
FunctionDescriptor representing the function RANK.public static final FunctionDescriptor DENSE_RANK
FunctionDescriptor representing the function DENSE_RANK.public static final FunctionDescriptor AVERAGE_RANK
FunctionDescriptor representing the function AVERAGE_RANK.public static final FunctionDescriptor ROW_NUMBER
FunctionDescriptor representing the function ROW_NUMBER.public static final FunctionDescriptor ABS
FunctionDescriptor representing the function ABS.public static final FunctionDescriptor ACOS
FunctionDescriptor representing the function ACOS.public static final FunctionDescriptor ASIN
FunctionDescriptor representing the function ASIN.public static final FunctionDescriptor ATAN
FunctionDescriptor representing the function ATAN.public static final FunctionDescriptor ATAN2
FunctionDescriptor representing the function ATAN2.public static final FunctionDescriptor BITAND
FunctionDescriptor representing the function BITAND.public static final FunctionDescriptor CEIL
FunctionDescriptor representing the function CEIL.public static final FunctionDescriptor COS
FunctionDescriptor representing the function COS.public static final FunctionDescriptor COSH
FunctionDescriptor representing the function COSH.public static final FunctionDescriptor EXP
FunctionDescriptor representing the function EXP.public static final FunctionDescriptor FLOOR
FunctionDescriptor representing the function FLOOR.public static final FunctionDescriptor LN
FunctionDescriptor representing the function LN.public static final FunctionDescriptor LOG
FunctionDescriptor representing the function LOG.public static final FunctionDescriptor MOD
FunctionDescriptor representing the function MOD.public static final FunctionDescriptor NANVL
FunctionDescriptor representing the function NANVL.public static final FunctionDescriptor POWER
FunctionDescriptor representing the function POWER.public static final FunctionDescriptor REMAINDER
FunctionDescriptor representing the function REMAINDER.public static final FunctionDescriptor ROUND_NUMBER
FunctionDescriptor representing the function ROUND.public static final FunctionDescriptor SIGN
FunctionDescriptor representing the function SIGN.public static final FunctionDescriptor SIN
FunctionDescriptor representing the function SIN.public static final FunctionDescriptor SINH
FunctionDescriptor representing the function SINH.public static final FunctionDescriptor SQRT
FunctionDescriptor representing the function SQRT.public static final FunctionDescriptor TAN
FunctionDescriptor representing the function TAN.public static final FunctionDescriptor TANH
FunctionDescriptor representing the function TANH.public static final FunctionDescriptor TRUNC_NUMBER
FunctionDescriptor representing the function TRUNC.public static final FunctionDescriptor WIDTH_BUCKET
FunctionDescriptor representing the function WIDTH_BUCKET.public static final FunctionDescriptor ASCII
FunctionDescriptor representing the function ASCII.public static final FunctionDescriptor CHR
FunctionDescriptor representing the function CHR.public static final FunctionDescriptor CONCAT
FunctionDescriptor representing the function CONCAT.public static final FunctionDescriptor INITCAP
FunctionDescriptor representing the function INITCAP.public static final FunctionDescriptor INSTR
FunctionDescriptor representing the function INSTR.public static final FunctionDescriptor INSTRB
FunctionDescriptor representing the function INSTRB.public static final FunctionDescriptor INSTRC
FunctionDescriptor representing the function INSTRC.public static final FunctionDescriptor INSTR2
FunctionDescriptor representing the function INSTR2.public static final FunctionDescriptor INSTR4
FunctionDescriptor representing the function INSTR4.public static final FunctionDescriptor LENGTH
FunctionDescriptor representing the function LENGTH.public static final FunctionDescriptor LENGTHB
FunctionDescriptor representing the function LENGTHB.public static final FunctionDescriptor LENGTHC
FunctionDescriptor representing the function LENGTHC.public static final FunctionDescriptor LENGTH2
FunctionDescriptor representing the function LENGTH2.public static final FunctionDescriptor LENGTH4
FunctionDescriptor representing the function LENGTH4.public static final FunctionDescriptor LOWER
FunctionDescriptor representing the function LOWER.public static final FunctionDescriptor UPPER
FunctionDescriptor representing the function UPPER.public static final FunctionDescriptor LPAD
FunctionDescriptor representing the function LPAD.public static final FunctionDescriptor RPAD
FunctionDescriptor representing the function RPAD.public static final FunctionDescriptor LTRIM
FunctionDescriptor representing the function LTRIM.public static final FunctionDescriptor RTRIM
FunctionDescriptor representing the function RTRIM.public static final FunctionDescriptor NLS_INITCAP
FunctionDescriptor representing the function NLS_INITCAP.public static final FunctionDescriptor NLSSORT
FunctionDescriptor representing the function NLSSORT.public static final FunctionDescriptor NLS_LOWER
FunctionDescriptor representing the function NLS_LOWER.public static final FunctionDescriptor NLS_UPPER
FunctionDescriptor representing the function NLS_UPPER.public static final FunctionDescriptor REGEXP_INSTR
FunctionDescriptor representing the function REGEXP_INSTR.public static final FunctionDescriptor REGEXP_COUNT
FunctionDescriptor representing the function REGEXP_COUNT.public static final FunctionDescriptor REGEXP_REPLACE
FunctionDescriptor representing the function REGEXP_REPLACE.public static final FunctionDescriptor REGEXP_SUBSTR
FunctionDescriptor representing the function REGEXP_SUBSTR.public static final FunctionDescriptor REPLACE
FunctionDescriptor representing the function REPLACE.public static final FunctionDescriptor SOUNDEX
FunctionDescriptor representing the function SOUNDEX.public static final FunctionDescriptor SUBSTR
FunctionDescriptor representing the function SUBSTR.public static final FunctionDescriptor SUBSTRB
FunctionDescriptor representing the function SUBSTRB.public static final FunctionDescriptor SUBSTRC
FunctionDescriptor representing the function SUBSTRC.public static final FunctionDescriptor SUBSTR2
FunctionDescriptor representing the function SUBSTR2.public static final FunctionDescriptor SUBSTR4
FunctionDescriptor representing the function SUBSTR4.public static final FunctionDescriptor TRANSLATE
FunctionDescriptor representing the function TRANSLATE.public static final FunctionDescriptor TREAT
FunctionDescriptor representing the function TREAT.public static final FunctionDescriptor TRIM
FunctionDescriptor representing the function TRIM.public static final FunctionDescriptor NLS_CHARSET_DECL_LEN
FunctionDescriptor representing the function NLS_CHARSET_DECL_LEN.public static final FunctionDescriptor NLS_CHARSET_ID
FunctionDescriptor representing the function NLS_CHARSET_ID.public static final FunctionDescriptor NLS_CHARSET_NAME
FunctionDescriptor representing the function NLS_CHARSET_NAME.public static final FunctionDescriptor ADD_MONTHS
FunctionDescriptor representing the function ADD_MONTHS.public static final FunctionDescriptor CURRENT_DATE
FunctionDescriptor representing the function CURRENT_DATE.public static final FunctionDescriptor CURRENT_TIMESTAMP
FunctionDescriptor representing the function CURRENT_TIMESTAMP.public static final FunctionDescriptor DBTIMEZONE
FunctionDescriptor representing the function DBTIMEZONE.public static final FunctionDescriptor EXTRACT_DATE
FunctionDescriptor representing the function EXTRACT.public static final FunctionDescriptor FROM_TZ
FunctionDescriptor representing the function FROM_TZ.public static final FunctionDescriptor LAST_DAY
FunctionDescriptor representing the function LAST_DAY.public static final FunctionDescriptor LOCALTIMESTAMP
FunctionDescriptor representing the function LOCALTIMESTAMP.public static final FunctionDescriptor MONTHS_BETWEEN
FunctionDescriptor representing the function MONTHS_BETWEEN.public static final FunctionDescriptor NEW_TIME
FunctionDescriptor representing the function NEW_TIME.public static final FunctionDescriptor NEXT_DAY
FunctionDescriptor representing the function NEXT_DAY.public static final FunctionDescriptor ROUND_DATE
FunctionDescriptor representing the function ROUND.public static final FunctionDescriptor TRUNC_DATE
FunctionDescriptor representing the function TRUNC.public static final FunctionDescriptor SESSIONTIMEZONE
FunctionDescriptor representing the function SESSIONTIMEZONE.public static final FunctionDescriptor SYS_EXTRACT_UTC
FunctionDescriptor representing the function SYS_EXTRACT_UTC.public static final FunctionDescriptor SYSDATE
FunctionDescriptor representing the function SYSDATE.public static final FunctionDescriptor SYSTIMESTAMP
FunctionDescriptor representing the function SYSTIMESTAMP.public static final FunctionDescriptor TO_DSINTERVAL
FunctionDescriptor representing the function TO_DSINTERVAL.public static final FunctionDescriptor TO_TIMESTAMP
FunctionDescriptor representing the function TO_TIMESTAMP.public static final FunctionDescriptor TO_TIMESTAMP_TZ
FunctionDescriptor representing the function TO_TIMESTAMP_TZ.public static final FunctionDescriptor TO_YMINTERVAL
FunctionDescriptor representing the function TO_YMINTERVAL.public static final FunctionDescriptor TZ_OFFSET
FunctionDescriptor representing the function TZ_OFFSET.public static final FunctionDescriptor GREATEST
FunctionDescriptor representing the function GREATEST.public static final FunctionDescriptor LEAST
FunctionDescriptor representing the function LEAST.public static final FunctionDescriptor ASCIISTR
FunctionDescriptor representing the function ASCIISTR.public static final FunctionDescriptor BIN_TO_NUM
FunctionDescriptor representing the function BIN_TO_NUM.public static final FunctionDescriptor CAST
FunctionDescriptor representing the function CAST.public static final FunctionDescriptor CHARTOROWID
FunctionDescriptor representing the function CHARTOROWID.public static final FunctionDescriptor COMPOSE
FunctionDescriptor representing the function COMPOSE.public static final FunctionDescriptor CONVERT
FunctionDescriptor representing the function CONVERT.public static final FunctionDescriptor DECOMPOSE
FunctionDescriptor representing the function DECOMPOSE.public static final FunctionDescriptor HEXTORAW
FunctionDescriptor representing the function HEXTORAW.public static final FunctionDescriptor NUMTODSINTERVAL
FunctionDescriptor representing the function NUMTODSINTERVAL.public static final FunctionDescriptor NUMTOYMINTERVAL
FunctionDescriptor representing the function NUMTOYMINTERVAL.public static final FunctionDescriptor RAWTOHEX
FunctionDescriptor representing the function RAWTOHEX.public static final FunctionDescriptor RAWTONHEX
FunctionDescriptor representing the function RAWTONHEX.public static final FunctionDescriptor ROWIDTOCHAR
FunctionDescriptor representing the function ROWIDTOCHAR.public static final FunctionDescriptor ROWIDTONCHAR
FunctionDescriptor representing the function ROWIDTONCHAR.public static final FunctionDescriptor SCN_TO_TIMESTAMP
FunctionDescriptor representing the function SCN_TO_TIMESTAMP.public static final FunctionDescriptor TIMESTAMP_TO_SCN
FunctionDescriptor representing the function TIMESTAMP_TO_SCN.public static final FunctionDescriptor TO_BINARY_DOUBLE
FunctionDescriptor representing the function TO_BINARY_DOUBLE.public static final FunctionDescriptor TO_BINARY_FLOAT
FunctionDescriptor representing the function TO_BINARY_FLOAT.public static final FunctionDescriptor CHAR_TO_CHAR
FunctionDescriptor representing the function TO_CHAR.public static final FunctionDescriptor NUMBER_TO_CHAR
FunctionDescriptor representing the function TO_CHAR.public static final FunctionDescriptor DATETIME_TO_CHAR
FunctionDescriptor representing the function TO_CHAR.public static final FunctionDescriptor INTERVAL_TO_CHAR
FunctionDescriptor representing the function TO_CHAR.public static final FunctionDescriptor TO_CLOB
FunctionDescriptor representing the function TO_CLOB.public static final FunctionDescriptor TO_DATE
FunctionDescriptor representing the function TO_DATE.public static final FunctionDescriptor TO_LOB
FunctionDescriptor representing the function TO_LOB.public static final FunctionDescriptor TO_MULTI_BYTE
FunctionDescriptor representing the function TO_MULTI_BYTE.public static final FunctionDescriptor CHAR_TO_NCHAR
FunctionDescriptor representing the function TO_NCHAR.public static final FunctionDescriptor NUMBER_TO_NCHAR
FunctionDescriptor representing the function TO_NCHAR.public static final FunctionDescriptor DATETIME_TO_NCHAR
FunctionDescriptor representing the function TO_NCHAR.public static final FunctionDescriptor INTERVAL_TO_NCHAR
FunctionDescriptor representing the function TO_NCHAR.public static final FunctionDescriptor TO_NCLOB
FunctionDescriptor representing the function TO_NCLOB.public static final FunctionDescriptor TO_NUMBER
FunctionDescriptor representing the function TO_NUMBER.public static final FunctionDescriptor TO_SINGLE_BYTE
FunctionDescriptor representing the function TO_SINGLE_BYTE.public static final FunctionDescriptor TRANSLATE_USING
FunctionDescriptor representing the function TRANSLATE.public static final FunctionDescriptor UNISTR
FunctionDescriptor representing the function UNISTR.public static final FunctionDescriptor DECODE
FunctionDescriptor representing the function DECODE.public static final FunctionDescriptor ORA_HASH
FunctionDescriptor representing the function ORA_HASH.public static final FunctionDescriptor DUMP
FunctionDescriptor representing the function DUMP.public static final FunctionDescriptor VSIZE
FunctionDescriptor representing the function VSIZE.public static final FunctionDescriptor COALESCE
FunctionDescriptor representing the function COALESCE.public static final FunctionDescriptor NULLIF
FunctionDescriptor representing the function NULLIF.public static final FunctionDescriptor NVL
FunctionDescriptor representing the function NVL.public static final FunctionDescriptor NVL2
FunctionDescriptor representing the function NVL2.public static final FunctionDescriptor LNNVL
FunctionDescriptor representing the function LNNVL.public static final FunctionDescriptor SYS_CONTEXT
FunctionDescriptor representing the function SYS_CONTEXT.public static final FunctionDescriptor SYS_GUID
FunctionDescriptor representing the function SYS_GUID.public static final FunctionDescriptor UID
FunctionDescriptor representing the function UID.public static final FunctionDescriptor USER
FunctionDescriptor representing the function USER.public static final FunctionDescriptor SYS_TYPEID
FunctionDescriptor representing the function SYS_TYPEID.public static final FunctionDescriptor USERENV
FunctionDescriptor representing the function USERENV.public static final FunctionDescriptor NO_AGGREGATE
FunctionDescriptor representing the function NO AGGREGATE.public static final FunctionDescriptor AGGREGATION_SUM
FunctionDescriptor representing the function SUM.public static final FunctionDescriptor AGGREGATION_AVG
FunctionDescriptor representing the function AVG.public static final FunctionDescriptor HIER_AVG
FunctionDescriptor representing the function HIER_AVG.public static final FunctionDescriptor AGGREGATION_FIRST
FunctionDescriptor representing the function FIRST.public static final FunctionDescriptor AGGREGATION_LAST
FunctionDescriptor representing the function LAST.public static final FunctionDescriptor HIER_FIRST
FunctionDescriptor representing the function HIER_FIRST.public static final FunctionDescriptor HIER_LAST
FunctionDescriptor representing the function HIER_LAST.public static final FunctionDescriptor AGGREGATION_MAX
FunctionDescriptor representing the function MAX.public static final FunctionDescriptor AGGREGATION_MIN
FunctionDescriptor representing the function MIN.public static final FunctionDescriptor AGGREGATE
FunctionDescriptor representing the function AGGREGATE.
|
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||