Functions
can be categorized as follows.
Ø Single row
functions
Ø Group
functions
SINGLE ROW FUNCTIONS
Single row functions can be categorized
into five. These will be applied for each row and produces individual output
for each row.
Ø Numeric
functions
Ø String
functions
Ø Date functions
Ø Miscellaneous
functions
Ø Conversion
functions
NUMERIC FUNCTIONS
Ø Abs
Ø Sign
Ø Sqrt
Ø Mod
Ø Nvl
Ø Power
Ø Exp
Ø Ln
Ø Log
Ø Ceil
Ø Floor
Ø Round
Ø Trunk
Ø Bitand
Ø Greatest
Ø Least
Ø Coalesce
STRING FUNCTIONS
Ø Initcap
Ø Upper
Ø Lower
Ø Length
Ø Rpad
Ø Lpad
Ø Ltrim
Ø Rtrim
Ø Trim
Ø Translate
Ø Replace
Ø Soundex
Ø Concat ( ‘ || ‘ Concatenation operator)
Ø Ascii
Ø Chr
Ø Substr
Ø Instr
Ø Decode
Ø Greatest
Ø Least
Ø Coalesce
DATE FUNCTIONS
Ø Sysdate
Ø Current_date
Ø Current_timestamp
Ø Systimestamp
Ø Localtimestamp
Ø Dbtimezone
Ø Sessiontimezone
Ø To_char
Ø To_date
Ø Add_months
Ø Months_between
Ø Next_day
Ø Last_day
Ø Extract
Ø Greatest
Ø Least
Ø Round
Ø Trunc
Ø New_time
Ø Coalesce
MISCELLANEOUS FUNCTIONS
Ø Uid
Ø User
Ø Vsize
Ø Rank
Ø Dense_rank
CONVERSION FUNCTIONS
Ø Bin_to_num
Ø Chartorowid
Ø Rowidtochar
Ø To_number
Ø To_char
Ø To_date
GROUP FUNCTIONS
Ø Sum
Ø Avg
Ø Max
Ø Min
Ø Count
