摘要:
declare TYPE t_cursor IS REF CURSOR; c_custids t_cursor; v_Date Date; v_branchid varchar2(3);BEGIN open c_custids for select * From (/*select distinct billingdate,branchid from tb_gos_sale_salestockoutsum where billingdate >to_date('2012-01-01','yyyy-mm-dd') union */ ... 阅读全文