Thursday, July 14, 2011

Oracle Built-in Functions

Oracle Built-in Functions
Version 11.1
 
Function Name
AnalyticCollectionConver
sion
Date
Time
Data MiningMisc.Model
Clause
Null
Handling
NumericObjectStringXML
ABS           
ACOS           
ADD_MONTHS           
ADJ_DATE           
APPENDCHILDXML           
ASCII           
ASCIISTR           
ASIN           
ATAN           
ATAN2           
AVG          
BFILENAME           
BIN_TO_NUM           
BINARY2VARCHAR           
BIT_COMPLEMENT           
BIT_OR           
BIT_XOR           
BITAND           
BOOL_TO_INT           
CARDINALITY           
CASE         
CAST           
CAST_FROM_BINARY
_DOUBLE
           
CAST_FROM_BINARY
_FLOAT
           
CAST_FROM_BINARY
_INTEGER
           
CAST_FROM_NUMBER           
CAST_TO_BINARY
_DOUBLE
           
CAST_TO_BINARY_FLOAT           
CAST_TO_BINARY
_INTEGER
           
CAST_TO_NUMBER           
CAST_TO_NVARCHAR2           
CAST_TO_RAW           
CAST_TO_VARCHAR           
CEIL           
CHARTOROWID           
CHR           
CLUSTER_ID           
CLUSTER_PROBABILITY           
CLUSTER_SET           
COALESCE          
COLLECT           
COMPOSE           
CONCAT          
CONVERT          
CORR          
CORR_K           
CORR_S           
COS           
COSH           
COUNT          
COVAR_POP          
COVAR_SAMP          
CUME_DIST          
CURRENT_DATE           
CURRENT_TIMESTAMP           
CV           
DBTIMEZONE           
DENSE_RANK          
DECODE         
DECOMPOSE           
DELETEXML           
DEPTH           
DEREF           
DUMP         
EMPTY_BLOB (large object)           
EMPTY_CLOB (large object)           
ESTIMATE_CPU_UNITS           
EXISTSNODE           
EXP           
EXTRACT          
EXTRACTVALUE           
FEATURE_ID           
FEATURE_SET           
FEATURE_VALUE           
FIRST          
FIRST_VALUE           
FLOOR           
FROM_TZ           
GET_CLOCK_TIME           
GET_DDL           
GET_DEPENDENT_DDL           
GET_DEPENDENT_XML           
GET_GRANTED_DDL           
GET_GRANTED_XDL           
GET_HASH           
GET_REBUILD_COMMAND           
GET_SCN           
GET_XML           
GREATEST          
GROUP_ID           
GROUPING           
GROUPING_ID           
HEXTORAW           
INITCAP           
INSERTCHILDXML           
INSERTXMLBEFORE           
INSTR           
INSTRB           
INSTRC           
INSTR2           
INSTR4           
INT_TO_BOOL           
INTERVAL           
ITERATE           
ITERATE UNTIL           
ITERATION_NUMBER           
LAG           
LAST           
LAST_DAY           
LAST_VALUE           
LEAD           
LEAST          
LENGTH        
LENGTHB         
LENGTHC         
LENGTH2         
LENGTH4         
LN           
LNNVL           
LOCALTIMESTAMP           
LOG           
LOWER           
LPAD           
LTRIM           
MAKEREF           
MAX        
MEDIAN           
MIN        
MONTHS_BETWEEN           
MOD           
NANVL           
NEW_TIME           
NEXT_DAY           
NHEXTORAW           
NLS_CHARSET_DECL_LEN           
NLS_CHARSET_ID           
NLS_CHARSET_NAME           
NLS_INITCAP           
NLS_LOWER           
NLSSORT           
NLS_UPPER           
NTILE           
NULLFN             
NULLIF           
NUMTODSINTERVAL           
NUMTOHEX  &         
NUMTOHEX2           
NUMTOYMINTERVAL           
NVL           
NVL2           
ORA_HASH           
PATH           
PERCENT_RANK          
PERCENTILE_CONT          
PERCENTILE_DISC          
POWER           
POWERMULTISET           
POWERMULTISET_BY_
CARDINALITY
           
PREDICTION           
PREDICTION_BOUNDS           
PREDICTION_COST           
PREDICTION_DETAILS           
PREDICTION_PROBABILITY           
PREDICTION_SET           
PRESENTNNV           
PRESENTV           
PREVIOUS           
QUOTE DELIMITERS           
RANDOMBYTES           
RANDOMINTEGER           
RANDOMNUMBER           
RANK          
RATIO_TO_REPORT           
RAW_TO_CHAR           
RAW_TO_NCHAR           
RAW_TO_VARCHAR2           
RAWTOHEX           
RAWTONHEX           
RAWTONUM           
RAWTONUM2           
REF           
REFTOHEX           
REGEXP_COUNT           
REGEXP_INSTR           
REGEXP_REPLACE           
REGEXP_SUBSTR           
REGR_AVGX          
REGR_AVGY          
REGR_COUNT          
REGR_INTERCEPT          
REGR_R2          
REGR_SLOPE          
REGR_SXX          
REGR_SXY          
REGR_SYY          
REMAINDER           
REPLACE           
REVERSE          
ROUND          
ROW_NUMBER           
ROWIDTOCHAR           
ROWIDTONCHAR           
RPAD           
RTRIM           
SCN_TO_TIMESTAMP           
SESSIONTIMEZONE           
SET           
SIGN           
SIN           
SINH           
SOUNDEX           
SQRT           
SQLCODE (exception)           
SQLERRM (exception)           
STATS_BINOMIAL_TEST           
STATS_CROSSTAB           
STATS_F_TEST           
STATS_KS_TEST           
STATS_MODE           
STATS_MW_TEST           
STATS_ONE_WAY_ANOVA           
STATS_T_TEST           
STATS_WSR_TEST           
STDDEV          
STDDEV_POP           
STDDEV_SAMP           
STRING_TO_RAW           
SUBSTR          
SUBSTRB           
SUBSTRC           
SUBSTR2           
SUBSTR4           
SUM          
SYS_CONNECT_BY_PATH (hierarchical)           
SYS_CONTEXT (environment)           
SYS_DBURIGEN           
SYS_EXTRACT_UTC           
SYS_GUID (identifier)           
SYS_OP_COMBINED_HASH           
SYS_OP_DESCEND           
SYS_OP_DISTINCT         
SYS_OP_GUID           
SYS_OP_LBID           
SYS_OP_MAP_NONNULL           
SYS_OP_RAWTONUM           
SYS_OP_RPB           
SYS_OP_TOSETID           
SYS_TYPEID           
SYS_XMLAGG           
SYS_XMLGEN           
SYSDATE           
SYSTIMESTAMP           
TABLE           
TAN           
TANH           
TIMESTAMP_TO_SCN           
TO_BINARYDOUBLE           
TO_BINARYFLOAT           
TO_CHAR           
TO_CLOB           
TO_DATE           
TO_DSINTERVAL           
TO_LOB           
TO_MULTI_BYTE           
TO_NCHAR           
TO_NCLOB           
TO_NUMBER           
TO_SINGLE_BYTE           
TO_TIMESTAMP           
TO_TIMESTAMP_TZ           
TO_YMINTERVAL           
TRANSLATE          
TRANSLATE USING          
TRANSLITERATE           
TREAT           
TRIM           
TRUNC          
TZ_OFFSET           
UID (environment)           
UNISTR           
UPDATEXML           
UPPER           
USER (environment)           
USERENV  (environment)           
VALUE (object)           
VAR_POP          
VAR_SAMP          
VARIANCE          
VERIFY_OWNER           
VERIFY_TABLE           
VERTICAL BARS           
VSIZE         
WIDTH_BUCKET           
XMLAGG           
XMLCAST           
XMLCDATA           
XMLCOLLATVAL           
XMLCOMMENT           
XMLCONCAT           
XMLDIFF           
XMLELEMENT           
XMLEXISTS           
XMLFOREST           
XMLISVALID           
XMLPARSE           
XMLPATCH           
XMLPI           
XMLQUERY           
XMLROOT           
XMLSEQUENCE           
XMLSERIALIZE           
XMLTABLE           
XMLTRANSFORM           
XOR