动态列核心代码

来源:互联网 发布:手机淘宝收获地址吗 编辑:程序博客网 时间:2024/05/22 14:39

 for ii_loop in 1 .. vv_biz_org_count     loop
       vv_sql3 := vv_sql3||'nvl(max(case when tmp1.biz_org_id in (select tmp2.biz_org_id
                                                                 from t_m_b_atm_withdraw_tmp2 tmp2
                                 where row_num = '||ii_loop||')  then tmp1.nu_of_voucher end),0),
 end loop;

0 0