교재 81, 82페이지 LAPD, RAPD 퀴즈

1. LAPD 

 

SELECT LPAD(ENAME, 9, '12345') "LPAD"
FROM emp
WHERE DEPTNO = 10;

 

2. RAPD

 

SELECT RPAD(ENAME, 9, SUBSTR('123456789', LENGTHB(ENAME) + 1, 9)) "RPAD"
FROM emp
WHERE DEPTNO = 10;