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.
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.