TECH
on the Net
Home
Privacy Policy
Feedback
Link to us
Site Map
Microsoft
Access
Excel
Word
Database
SQL
Oracle / PLSQL
UNIX
General UNIX
Linux
Other
Ascii Table
Java
Clipart
Joke of the Moment
Top 10 Pages
Oracle / PLSQL
SQL
Access
Excel
ADVERTISEMENT
Oracle/PLSQL Topics: Built-In Functions (Alphabetical)
View Functions By Category
Alphabetical Listing of Functions:
Abs
Greatest
Sin
Acos
Group_ID
Sinh
Add_Months
HexToRaw
Soundex
Ascii
Initcap
SQLCODE
AsciiStr
Instr
SQLERRM
Asin
Lag
Sqrt
Atan
Last_Day
StdDev
Atan2
Lead
Substr
Avg
Least
Sum
BFilename
Length
Sys_Context
Bin_To_Num
LNNVL
Sysdate
BitAnd
Ln
SysTimestamp
Cardinality
LocalTimestamp
Tan
Case Statement
Log
Tanh
Cast
Lower
To_Char
Ceil
Lpad
To_Clob
CharToRowid
Ltrim
To_Date
Chr
Max
To_DSInterval
Coalesce
Median
To_Lob
Compose
Min
To_Multi_Byte
Concat
Mod
To_NClob
Concat with ||
Months_Between
To_Number
Convert
NANVL
To_Single_Byte
Corr
New_Time
To_Timestamp
Cos
Next_Day
To_Timestamp_Tz
Cosh
NULLIF
To_YMInterval
Count
NumToDSInterval
Translate
Covar_pop
NumToYMInterval
Trim
Covar_samp
NVL
Trunc (dates)
Cume_Dist
NVL2
Trunc (numbers)
Current_Date
Power
Tz_Offset
Current_Timestamp
Rank
Uid
DbTimeZone
RawToHex
Upper
Decode
Remainder
User
Decompose
Replace
UserEnv
Dense_Rank
Round (dates)
Var_pop
Dump
Round (numbers)
Var_samp
Exp
Rpad
Variance
Extract
Rtrim
VSize
Floor
SessionTimeZone
From_Tz
Sign
Miscellaneous Functions:
Retrieve user ID from the current Oracle session
Retrieve the session ID for the user logged in