aaa,bbb
11.20 How to use LENGTH( )
function
To find out the no of characters in any column or text data, we need to use the following syntax:
Syntax: select length( ',aaa,bbb,') as result from dual;
Result :
Result
- - - - -
9
11.21 How to use INSTR( ) function
To find out the position of required characters on the occurrence in any column or text data, we need to use the following syntax:
instr( column-nameldata , to be located characters set, start from , occurrence )
instr( ',aaa,bbb,' , ',' , 1 , 2 )
Syntax: select instr( ',aaa,bbb,',',', 1,2) as result from dual;
Result :
Result