Regular expressions in SQL?

Question

I want to use regex in Oracle 11g SQL to find records that don't match it. Regular expression:

/([A-Z]{3})+([0-9])\w+/g

The SQL I want to use would be something like this:

select
  stu_code
  ,stu_insc
from
  intuit.ins_stu
where
  stu_insc not like ('/([A-Z]{3})+([0-9])\w+/g')

Obviously I know this is wrong, so does anyone know how I do this? I do not have permission to run PL / SQL.

+3

Andy Kaufman Dec 17. 14 at 14:39

1 answer

piet.t · Accepted Answer · 2014-12-17T14:45:25+0000

In oracle, you can try something line by line

select xyz
from theTable
where not regexp_like(mycolumn,pattern)