--多表插入
BEGIN
INSERT ALL
WHEN vendor_id = 2 THEN
INTO cux_vendor_1(vendor_id, vendor_name) VALUES (vendor_id, vendor_name)
WHEN vendor_id = 3 THEN
INTO cux_vendor_2(vendor_id, vendor_name) VALUES(vendor_id, vendor_name)
WHEN vendor_id = 5 THEN
INTO cux_vendor_3 (vendor_id, vendor_name)VALUES (vendor_id, vendor_name)
WHEN vendor_id = 6 THEN
INTO cux_vendor_2(vendor_id, vendor_name) VALUES(vendor_id, vendor_name)
INTO cux_vendor_3 (vendor_id, vendor_name)VALUES (vendor_id, vendor_name)
SELECT * FROM po_vendors t WHERE t.vendor_id IN (2,3,5,6);
END;
select * FROM cux_vendor_1;
select * FROM cux_vendor_2;
select * FROM cux_vendor_3;
create table CUX_VENDOR_1
(
vendor_id NUMBER,
vendor_name VARCHAR2(240)
);
create table CUX_VENDOR_2
(
vendor_id NUMBER,
vendor_name VARCHAR2(240)
);
create table CUX_VENDOR_3
(
vendor_id NUMBER,
vendor_name VARCHAR2(240)
);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25684327/viewspace-692719/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25684327/viewspace-692719/