

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