Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

Find the s and ignore case

SQL> SQL> SELECT REGEXP_INSTR('This is a test for print SS','s',1,1,0,'i') position   2  FROM dual;   POSITION ----------          4 SQL>