Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

REGEXP_INSTR(Mississippi, si, 1,2,0,i)

SQL> SQL> SELECT REGEXP_INSTR('Mississippi', 'si', 1,2,0,'i') FROM dual; REGEXP_INSTR('MISSISSIPPI','SI',1,2,0,'I') ------------------------------------------                                          7 SQL>