Regular expressions in SQL?

Question

I want to use a regular expression in Oracle 11g SQL to find records that do not match it. The regular expression is:

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

The SQL I want to use would be something like:

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

Obviously I know the above is not right, so does anyone know how I do this? I do not have the rights to run any PL/SQL.

@vks I'm trying to find records where stu_insc does not match the regular expression mentioned above — Andy Kaufman
– Andy Kaufman, Commented Dec 17, 2014 at 14:42

piet.t · Accepted Answer · 2014-12-17 14:45:25Z

4

On oracle you can try something along the lines of

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

answered Dec 17, 2014 at 14:45

piet.t

11.9k21 gold badges45 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1