Functions in Oracle

Example of Functions

--concat
select concat(concat('Adams','martin'),' Rodrick') from dual;
Ans->Adamsmartin Rodrick
--initcap
select INITCAP('adams martin rodrick') from dual;
Ans->Adams Martin Rodrick
--LOWER
select LOWER('LOWER CASE EXAMPLE') from dual;
Ans->lower case example
--upper
select UPPER('upper case example') from dual;
Ans->UPPER CASE EXAMPLE
--UCASE
select UCASE('upper case example') from dual;
Ans->UPPER CASE EXAMPLE
--LPAD
select first_name,LPAD(SALARY,length(salary)+1,'$')from EMPLOYEES
Ans->Steven $24000
--LTRIM
select LTRIM('xyxYyXz WORD','xy') from dual;
Ans->YyXz WORD
--replace
select replace('lets learn','learn','earn') from dual;
Ans->lets earn
--RPAD
select RPAD('PASSION',12,'x') from dual
Ans->PASSIONxxxxx
--LPAD
select LPAD('Rodrick',15,'Mr ') from dual;
Ans->Mr Mr MrRodrick
--trim
select trim(' Rodrick ') from dual;
Ans->Rodrick