Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

11.14   How to use LPAD ( )

function

11.15   How to use CONCAT

function

SYNTAX:   select concat ('RPT', LPAD (1027, 6, '0')) "Voucher-number" from dual;

RESULT:

VOUCHER-NUMBER RPT001027

Instead of left side padding if required right side padding, we may use RPAD command,

11.16   How to use substr( )

function

Another frequently used function and we may require in our proposed application development will be SUBSTR( ) called as substring function, This function also has three parameter options

string or column-name

starting position