全部博文
-
编辑 删除
oracle10g的forall功能加强
oracle10g的forall功能加强[@more@]In Oracle Database 10g, PL/SQL now offers two new clauses in the FORALL statement, INDICES OF and VALUES OF, which allow you to choose very selectively which rows from the driving array should be processed by the extended DML statement. 看个例子：--all_orders所有订单；new_records新增加订单（状态1）；orders_archive无效订单（状态0）create table all_orders(id number(18) primary key,mc varchar2(60),order_status number(2));create table new_orders(id number(18) primary
