Oracle Built-in Functions

本文详细介绍Oracle数据库中各种内置函数的使用方法及应用场景,包括数学函数、字符串函数、日期时间函数等,为数据库开发者提供全面的技术参考。

点击打开链接

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           

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值