Single Row Functions In SQL

SINGLE ROW FUNCTIONS IN SQL

Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, where clauses, startwith and connect by clauses, and having clauses.

CASE MANIPULATION FUNCTIONS

 UPPER()
lOWER()
INITCAP()

CHARACTER MANIPULATION FUNCTION

LENGHT()
CONCAT()
REVERSE()
INSTR() SUBSTR()
LTRIM() RTRIM()
LPAD() RPAD()
REPlACE()
TRANSLATE()

NUMBER FUNCTIONS

ROUND()
TRUNC()
POWER()
MOD()

GENERAL FUNCTION 

NVL()
NVL2()
NULLIF()
COALESCE()

DATE FUNCTIONS

ADD_MONTHS()
MONTHS_BETWEEN()
NEXT_DAY()
LAST_DAY()