Using RPAD in PLSQL Query

https://randomsrsolutions.blogspot.com/2018/05/using-rpad-in-plsql-query.html

Pads the Character value left-justified

select EMPNO,  RPAD(ENAME,9,'.') ENAME, LPAD(JOB,10,'.') JOB, SAL from EMP
where ENAME = 'KING';

EMPNO      ENAME           JOB                        SAL
7839             KING.....          .PRESIDENT          5000