Oracle Functions

From PostgreSQL wiki
Jump to: navigation, search

This is work in progress

Numeric Functions

Oracle Function Postgres
ABS ABS
ACOS ACOS
ASIN ASIN
ATAN ATAN
ATAN2 ATAN2
BITAND & (Operator)
CEIL CEIL
COS COS
COSH by extension orafce
EXP EXP
FLOOR FLOOR
LN LN
LOG LOG
MOD MOD or & (Operator)
NANVL Currently no known implementation
POWER POWER
REMAINDER Currently no known implementation
ROUND (number) ROUND (number)
SIGN SIGN
SIN SIN
SINH by extension orafce
SQRT SQRT
TAN TAN
TANH by extension orafce
TRUNC (number) TRUNC (number)
WIDTH_BUCKET WIDTH_BUCKET

Character Functions Returning Character Values

Character Functions Returning Number Values

Character Set Functions

Collation Functions

Datetime Functions

General Comparison Functions

Conversion Functions

Large Object Functions

Collection Functions

Hierarchical Functions

Data Mining Functions

XML Functions

JSON Functions

Encoding and Decoding Functions

NULL-Related Functions

Environment and Identifier Functions