Running the below code throws an error when run on SQL Developer:
SELECT REGEXP_LIKE('CTCP AYD 0404370713 M', 'CTCH.*[0-9]/{0,1}.*', 'i') FROM DUAL;
Error message:
ORA-00904: "REGEXP_LIKE": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 40 Column: 8
Not sure why this is throwing up error when REGEXP_LIKE()
function is available in oracle.
Any views from Oracle db gurus?
regexp_like
is a condition. Use it in thewhere
clause or other places with boolean comparisons - e.g.case
expressions: