oracle子程序存储过程和函数.pptVIP

1 * 使用显式游标更新行-1 允许使用游标删除或更新活动集中的行 声明游标时必须使用 SELECT … FOR UPDATE语句 CURSOR cursor_name IS SELECT statement FOR UPDATE; UPDATE table_name SET set_clause WHERE CURRENT OF cursor_name 更新的语法 DELETE FROM table_name WHERE CURRENT OF cursor_name 删除的语法 * 使用显式游标更新行-2 SQL SET SERVEROUTPUT ON SQL DECLARE new_price NUMBER; CURSOR cur_toy IS SELECT toyprice FROM toys WHERE toyprice100 FOR UPDATE OF toyprice; BEGIN OPEN cur_toy; LOOP FETCH cur_toy INTO new_price; EXIT WHEN cur_toy%NOTFOUND; UPDATE toys SET toyprice = 1.1*new_price WHERE CURRENT OF cur_toy;