Oracle/PLSQL Built-In Functions

Oracle/PLSQL Built-In Functions

今天发现的一个很不错的网站，对常见函数有个很好的讲解，本来还想自己整理一下，学了这么长时间都没有系统的整理过，看了这个确实不错，值得一看。有不少例子，虽然有些确实很简单，没有必要举例，但是也足以见证笔者的耐心和负责。在此我把这里粘贴过来，不过都是引用的该网站的链接。

 

Character / String Functions(字符处理函数）
	Ascii	Convert	Lower	Soundex
	AsciiStr	Decompose	Lpad	Substr
	Chr	Dump	Ltrim	Translate
	Compose	Initcap	Replace	Trim
	Concat	Instr	Rpad	Upper
	Concat with ||	Length	Rtrim	VSize

Conversion Functions:(转换函数）
	Bin_To_Num	NumToDSInterval	To_Date	To_Number
	Cast	NumToYMInterval	To_DSInterval	To_Single_Byte
	CharToRowid	RawToHex	To_Lob	To_Timestamp
	From_Tz	To_Char	To_Multi_Byte	To_Timestamp_Tz
	HexToRaw	To_Clob	To_NClob	To_YMInterval

Advanced Functions:(高级函数)
	BFilename	Group_ID	NULLIF	User
	Cardinality	Lag	NVL	UserEnv
	Case Statement	Lead	NVL2
	Coalesce	LNNVL	Sys_Context
	Decode	NANVL	Uid

Mathematical Functions:(数学相关函数）
	Abs	Covar_pop	Max	Sqrt
	Acos	Covar_samp	Median	StdDev
	Asin	Count	Min	Sum
	Atan	Cume_Dist	Mod	Tan
	Atan2	Dense_Rank	Power	Tanh
	Avg	Exp	Rank	Trunc (numbers)
	Bin_To_Num	Extract	Remainder	Trunc (dates)
	BitAnd	Floor	Round (numbers)	Var_pop
	Ceil	Greatest	Round (dates)	Var_samp
	Corr	Least	Sign	Variance
	Cos	Ln	Sin
	Cosh	Log	Sinh

Date Functions:(日期函数)
	Add_Months	Last_Day	Round	To_Date
	Current_Date	LocalTimestamp	SessionTimeZone	Trunc
	Current_Timestamp	Months_Between	Sysdate	Tz_Offset
	DbTimeZone	New_Time	SysTimestamp
	From_Tz	Next_Day	To_Char

Error Functions:(关于错误代码的函数）
	SQLCODE
	SQLERRM

转载于:https://blog.51cto.com/shitou118/287050