17,090
社区成员
发帖
与我相关
我的任务
分享
INSERT ALL
WHEN ottl < 100000 THEN
INTO small_orders
VALUES(oid, ottl, sid, cid)
WHEN ottl > 100000 and ottl < 200000 THEN
INTO medium_orders
VALUES(oid, ottl, sid, cid)
WHEN ottl > 200000 THEN
into large_orders
VALUES(oid, ottl, sid, cid)
WHEN ottl > 290000 THEN
INTO special_orders
SELECT o.order_id oid, o.customer_id cid, o.order_total ottl,
o.sales_rep_id sid, c.credit_limit cl, c.cust_email cem
FROM orders o, customers c
WHERE o.customer_id = c.customer_id;
for rec in
(
select * from A where ……
)
loop
insert into B(……) values (rec.你要的字段,rec.你要的字段) where ……;
insert into C(……) values (rec.你要的字段,rec.你要的字段) where ……;
update A;
end loop;