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

AVG 
CORR 
COUNT 
COVAR_POP 
COVAR_SAMP 
CUME_DIST
DENSE_RANK
FIRST
FIRST_VALUE 
LAG
LAST
LAST_VALUE 
LEAD
LISTAGG
MAX 
MEDIAN
MIN 
NTH_VALUE 
NTILE
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
RANK
RATIO_TO_REPORT
REGR_ (Linear Regression) Functions 
ROW_NUMBER
STDDEV 
STDDEV_POP 
STDDEV_SAMP 
SUM 
VAR_POP 
VAR_SAMP
VARIANCE