Oracle SQL Functions List - Most Used

Single-Row Functions

CONCAT

• SELECT CONCAT('Alp','er') from dual; -- Alper

INITCAP

• SELECT INITCAP('alper') from dual; -- Alper

LOWER

• SELECT LOWER('AlpeR') from dual; -- alper

• SELECT UPPER('alPer') from dual; -- ALPER

LENGTH

• SELECT LENGTH('Alper') from dual; -- 5

SUBSTR

• SELECT SUBSTR('Alper',4,2) from dual; -- er
• SELECT SUBSTR('Alper',-2,2) from dual; -- er
• SELECT SUBSTR('Alper',1) from dual; -- Alper

INSTR

• SELECT INSTR('Alper') from dual; -- 5
• SELECT INSTR('Alper','A',1,1) from dual; -- 1
• SELECT INSTR('Alper','e',-2,1) from dual; -- 4

LPAD

• SELECT LPAD(1000000,10,'$' ) from dual; -- $$$1000000

RPAD

• SELECT RPAD(1000000,10,'$' ) from dual; -- 1000000$$$

REPLACE

• SELECT REPLACE('AliVeli','iVeli','per') from dual; -- Alper

TRIM

• SELECT TRIM('A l p e r') from dual; -- Alper
• SELECT TRIM(leading 'X' from 'XXXXAlper') from dual; -- Alper
• SELECT TRIM(trailing 'Y' from 'AlperYYY') from dual; -- Alper