![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
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