PL/SQL regex check

Question

I have following regex for C#. It checks for 3 capital letters followed by 3 digits.

string reg = @"^[A-Z]{3}\d{3}";

Is it possible to write same kind of regex for PL/SQL? I am new to this.

Example valid text:

ABS123
AHS243
OPS234

Answer 1

There has been SQL support for regular expressions since Oracle 10g. Not sure how you want to use it, but perhaps you need something like this?

where regexp_like(your_column, '^[A-Z]{3}\d{3}')

There is pretty good support for Posix regular expressions. Find out more.