79636306

Date: 2025-05-24 00:01:02
Score: 2.5
Natty:
Report link

You should use 'dotall' modifier. Often it is 's' in other languages and here 'n', it's easy to miss it in documentation.

By the way, why you're using NOT is it some trick for optimizer?

SELECT CASE WHEN REGEXP_LIKE(MYSTRING, '^[a-zA-Z0-9]*$', 'n') THEN 'valid'
       ELSE 'invalid'
       END 
FROM DUAL
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Low reputation (0.5):
Posted by: Sergey Soltanov