2011年
-
编辑 删除
Insert All多表插入用法
--多表插入BEGININSERT 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_i...
-
编辑 删除
PLSQL Bulk collect-Forall用法
-- CREATE TABLE cux_vendor (vendor_id NUMBER,vendor_name VARCHAR2(240)); PROCEDURE bulk_collect IS TYPE l_vendor_id_tab IS TABLE OF NUMBER INDEX BY BINARY_IN...
