Saturday, August 27, 2016

Oracle SQL Functions

SQL Functions

Functions perform specific action and returns results

There are two types of functions .

Single Row Functions  :  return one result for each row
Multi Row Functions : return one result for multiple rows.


Character Functions
LOWER
UPPER
INITCAP
CONCAT
SUBSTR
LENGTH
LPAD
RPAD
TRIM
REPLACE
Number Functions
ROUND
TRUNC
CEIL
FLOOR
MOD
Date Functions
SYSDATE
CURRENT_DATE
CURRENT_TIMESTAMP
MONTHS_BETWEEN
ADD_MONTHS
NEXT_DAY
LAST_DAY
ROUND
TRUNC
Conversion Functions
TO_CHAR
TO_DATE
TO_NUMBER
NVL
NVL2
NULLIF
COALESC
CASE
Searched CASE
DECODE
General Functions
Group Functions
AVG
COUNT
SUM
MIN
MAX
LISTAGG
STDDEV
VARIANCE
Grouping Rows
GROUP By
HAVING

Analytical Functions

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts