动态条件查询

Oracle

select t.*,rownum rn 
from AQ_CHECK_INFO t
where decode(t.create_user_id,'','1',t.create_user_id)=decode('109e826e-afc3-4adb-aeba-bd993fa94f9f','','1','109e826e-afc3-4adb-aeba-bd993fa94f9f');
and xmgljg=decode(:xmgljg,'',xmgljg,:xmgljg)