Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

Regexp_instr (string, pattern, position, occurence, return-option, parameters)

SQL> SQL> SQL> -- Find the 's' and match case. SQL> SQL> SELECT REGEXP_INSTR('Sam told a story','s',1,1,0,'c') position FROM dual;   POSITION ----------         12 SQL>