Technical Blog

Contains alphabets SELECT * FROM test WHERE REGEXP_LIKE(testcol, '[[:alpha:]]') Contains only alphabets SELECT * FROM test W...

Find the position of try, trying, tried or tries SELECT REGEXP_INSTR('We are trying to make the subject easier','tr(y(ing)?|(...

REGEXP_LIKE SELECT * FROM scott.emp WHERE REGEXP_LIKE(ENAME,'FR') ; OR SELECT * FROM scott.emp WHERE ENAME LIKE '%FR%'...