Oracle PL/SQL Instr Example

Select INSTR('Instr Test',' ',1,3) From dual;

Select INSTR( 'London', 'don' ) result From dual;

Select SUBSTR('ora,for,tic', INSTR('ora,for,tic',',', 1, 2)+1) From dual;