Single-Row Functions
CONCAT
- SELECT CONCAT('Alp','er') from dual; -- Alper
- SELECT INITCAP('alper') from dual; -- Alper
- SELECT LOWER('AlpeR') from dual; -- alper
- SELECT UPPER('alPer') from dual; -- ALPER
- SELECT LENGTH('Alper') from dual; -- 5
- SELECT SUBSTR('Alper',4,2) from dual; -- er
- SELECT SUBSTR('Alper',-2,2) from dual; -- er
- SELECT SUBSTR('Alper',1) from dual; -- Alper
- SELECT INSTR('Alper') from dual; -- 5
- SELECT INSTR('Alper','A',1,1) from dual; -- 1
- SELECT INSTR('Alper','e',-2,1) from dual; -- 4
- SELECT LPAD(1000000,10,'$' ) from dual; -- $$$1000000
- SELECT RPAD(1000000,10,'$' ) from dual; -- 1000000$$$
- SELECT REPLACE('AliVeli','iVeli','per') from dual; -- Alper
- 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