v_sql := 'select nvl(sum(componentqty),0) from mfg_tbl_info_wip_hourly_iiwhere lottype in v_lottypeand productname not like ''RW%''and stage not in (select distinct stage from probe_stage where type = ''ALL'')and adstatus != ''Bank''and histdate=to_char(sysdate,''yyyymmdd'')and hour= v_cuthour';dbms_output.put_line(v_sql); --执行execute immediate v_sql into v_eoh;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024