select t.*, t.rowid from sm_user t where exists (select t2.* from ( select 'ff' a from dual union select 'test' a from dual) t2 where t.real_name like '%' || t2.a || '%');
[img]http://dl2.iteye.com/upload/attachment/0113/6355/96f31f32-a89a-3853-8a54-21e5977c1d27.png[/img]