Using LPAD in PLSQL Query

Pads the Character Value right-justified

select LPAD('PAK',7,'*') from dual;
****PAK

select LPAD('PAK',7,' ') from dual;
    PAK

select LPAD('PAK',7,'->') from dual;
->->PAK

select LPAD('PAK',7,'123-') from dual;
123-PAK

select LPAD('4265550',12,'0321-') from dual;
0321-4265550

select LPAD('4265550',11,'021-') from dual;
021-4265550

----------------------------------------------------------------------------------------------------

select EMPNO, ENAME , LPAD(EMPNO,8,'ORA-') NEW_EMPNO,
LPAD(ENAME,15,'.') ENAME, LPAD(ENAME,15,' ') ENAME from EMP
where ENAME = 'KING';

EMPNO      ENAME       NEW_EMPNO      ENAME_1            ENAME_2
7839            KING           ORA-7839             ...........KING                    KING