SELECT INITCAP(‘the soap bangladesh’) “Capitals” FROM DUAL;
SELECT LOWER(‘MR. SCOTT MCMILLAN’) “Lowercase” FROM DUAL;
SELECT UPPER(‘asraf’) “Uppercase” FROM dual;
select concat(‘Jewel’,’ Asraf’) from dual;
SELECT SUBSTR(‘MR.JEWEL’,4,5) FROM DUAL;
SELECT length(‘MR.JEWEL’) FROM DUAL;
SELECT instr(‘MR.JEWEL’,’.’) FROM DUAL;
select LPAD(121331, 12, ‘0’) “LPAD” from dual;
select lpad(sal,6,’0′) from emp;
select RPAD(121331, 12, ‘0’) “LPAD” from dual;
select rpad(ename,20,’-Oracle Student’) from emp;
SELECT LTRIM(‘Jewel’, ‘J’) FROM dual;
SELECT RTRIM(‘Jewel’, ‘l’) FROM dual;
select trim(‘ Jewel Sharmin ‘) from dual;
select trim(ename) from emp;

Suggested Posts:

Leave a Reply