Question

ORA-01722: 无效数字

select o from Scenic o where o.nameCn like'%崂山风景名胜区%' and o.auditState=4 order by o.recDegree desc
[dtss] 2013-06-05 10:32:16,882 ERROR [http-8080-1] org.hibernate.util.JDBCExceptionReporter.logExceptions-78 | ORA-01722: 无效数字

Answer 1

select * from user
where
INSTR( (select ',' || field || ',' from table_a where id = 1), ',' || TRIM(TO_CHAR(user_id )) || ',' ) > 0