oracle动态条件

2019独角兽企业重金招聘Python工程师标准>>>

--动态条件

1、SELECT *
  FROM cgidata.nbz_rcl_rul_tsk_stat_rela t
 WHERE t.tsk_stat_cod > '1'
   AND (((
       CASE
              WHEN t.tsk_stat_dtl_cod IS NULL THEN
                   0
             ELSE
                   1   
        end)=1) and t.tsk_stat_dtl_cod > 'TD_031')

2、

select * from table1
where A>2 and c=nvl('变量',c)

转载于:https://my.oschina.net/u/729507/blog/77457