一般的专制嵌套可以用几个表连络起来发芽就能替代,但有时却不能庖代,好比,第二个要发芽的值是第一个查出值后再进行like运算 declare
# M% A0 {3 I! X% M1 I v_1 number;& X# N5 m" m4 _6 _
cursor c1 is select productordernumber from his_productorder@pro_crm where productid in (9000045516);
: n/ g6 _# {' Y/ X% ^9 D* c cursor c2 is select cust_order_id from suf_cust_order_q_his where cust_order_num like v_0||'%';' u0 V% E$ v0 ] v. w2 }
cursor c3 is select * from suf_work_order_q_his where cust_order_id=v_1;& D& k+ S7 @* S1 ~+ y A3 A) Q# [
begin2 F; p$ \- Q2 ]8 `9 M
for i in c1 loop' d; N T! n- Q6 [3 ~
v_0:=i.productordernumber;
4 j+ [. A% u! R* v; U3 c for j in c2 loop
% S$ d( a& [7 d; L v_1:=j.cust_order_id;9 S0 G0 [! `+ Y7 Y ]
for k in c3 loop
2 J* s, J/ w& _5 M dbms_output.put_line(k.work_order_id||' '||k.status);6 {, @0 i* h3 b" \' B4 q4 f
end loop;, q1 W% Q3 m- ~" R; A6 t
end loop;1 W4 [' i. O2 \2 W; y/ L
v_0 number;
+ }! H( C n" z- ~; p; n6 f; w% k --------------------3 G' O1 s7 r6 }5 o
end loop; |