sql - Oracle : Alternative of REGEXP_LIKE function in Oracle 8i -

i have sql uses regexp_like function in clause, need equivalent of function run in oracle 8i.

the regex this:

where regexp_like(parm, '^[pmf][[:digit:]]+[_].*')

thanks in advance.

you try

where substr(parm,1,1) in ('p','m','f') , substr(parm,2,1) between '0' , '9' , substr(ltrim(substr(parm,2),'0123456789'),1,1) = '_'

first character p, m or f. second character digit second character onwards, stripping digits left, should start underscore

ps. please shoot 8i database. not 8i out of support, 9i , 10g out of support (or @ least in 'degraded, please stop using them' level of support).

Expalin