Click to See Complete Forum and Search --> : Oracle Regular Expressions


Charles
02-19-2009, 02:40 PM
select WO_LOG_OPEN_VALUE, count (*) as "Num"
from INF_WO_LOGGING
where WO_LOG_CODE = 'DDEBRIS' and regexp_like (WO_LOG_OPEN_VALUE, '\W')
group by WO_LOG_OPEN_VALUE
error:
ERROR at line 4:
ORA-00920: invalid relational operator

Thanks.

Charles
02-19-2009, 03:15 PM
Problem solved such as it is. This version of Oracle is pre-version 10 which is when they started with the regular expressions.