Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. LPAD() and RPAD()
Syntax:LPAD(,  [,])
RPAD(,   [,])
SQL> SELECT
  2     LPAD('ABC',6,'***') result
  3  FROM dual;
RESULT
------
***ABC
SQL>