oracle 逆相查询

SELECT *
  FROM cop_customer_project_mv t
 WHERE t.fcust_party_id = 566110
   AND  '1,2,3,4,5' like '%' || nvl(t.FSTEP_CODE,'@@@@@')  || '%'
 ORDER BY t.fstart_date DESC

posted @ 2017-05-04 14:12  albert_think  阅读(204)  评论(0编辑  收藏  举报