oracle函数手册

Oracle Built-in Functions Version 10.2 Function Name Analytic Collection Conver sion Date Time Data Mining Misc. Model Clause Null Handling Numeric Object String XML ABS ACOS ADD_MONTHS ADJ_DATE APPENDCHILDXML ASCII ASCIISTR ASIN ATAN ATAN2 AVG BFILENAME BIN_TO_NUM 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 NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NLS_INITCAP NLS_LOWER NLSSORT NLS_UPPER NTILE NULLIF NUMTODSINTERVAL NUMTOHEX 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 REF REFTOHEX 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 SCNTOTIMESTAMP 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_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 TIMESTAMPTOSCN 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 Contact Us � Legal Notices and Terms of Use � Privacy Statement