Numeric Function in SQL- Single Row 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
26
➢ Least
➢ Coalesce