Can anyone offer up an alternative to the function REGEXP_LIKE in Oracle that is currently being used in a Check Constraint. Here is an example of the Oracle Check Constraint (in a CREATE TABLE script) that I am attempting to translate:
CONSTRAINT CK_ROLLOFF_TAG_AC CHECK (LENGTH(frc_code) = 1 OR REGEXP_LIKE(frc_code,'^[[:digit:]]{1,2}$') ),
Your help and/or advice would be greatly appreciated.