Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

REGEXP_INSTR(abc,d)

SQL> SQL> -- if we include the "?" repetition character, we get this seemingly odd result: SQL> SQL> SELECT REGEXP_INSTR('abc','d?') FROM dual; REGEXP_INSTR('ABC','D?') ------------------------                        1 SQL>