Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Get the sub string position by using instr

SQL> SQL> select instr( 'Samantha', 'man' ) position from dual;   POSITION ----------          3 1 row selected. SQL> SQL> --