number of characters needed from the starting position
SUBSTR ((string, start, count), Assume RPT-001027 is a string; I want to pick out 1027, One is located in 7th position and followed 4 characters (count) needed, SYNTAX: select SUBSTR ('RPT-001027',7,4) AS RETURN-VALUE FROM DUAL;
RESULT :
RETURN-VALUE
1027
11.17 How to use LTRIM( )
function
When we need to remove left most unwanted or to be eliminated characters on the column we need to use the following syntax:
Syntax: select ltrim(',aaa,bbb,',',') as result from dual;
Result :
Result
- - - - - aaa,bbb,