update, delete 하면서 처리된 레코드의 값들을 얻는 방법

var bnd1 NUMBER
var bnd2 VARCHAR2(30)
var bnd3 NUMBER

UPDATE employees
SET job_id ='SA_MAN', salary = salary + 1000,
department_id = 140
WHERE last_name = 'Jones'
RETURNING salary*0.25, last_name, department_id
INTO :bnd1, :bnd2, :bnd3;

print bnd1
print bnd2
print bnd3
[오후 5:52:38] 김유승, hanulis 님의 말: update한 값을 bnd1,2,3에 return
[오후 6:02:31] 김유승, hanulis 님의 말: RETURNING empno BULK COLLECT INTO enums;
[오후 6:06:11] 김유승, hanulis 님의 말: SQL> create or replace procedure fast_proc is
2         type TObjectTable is table of ALL_OBJECTS%ROWTYPE;
3         ObjectTable$ TObjectTable;
4         begin
5         select
6                     * BULK COLLECT INTO ObjectTable$
7         from ALL_OBJECTS;
8
9         forall x in ObjectTable$.First..ObjectTable$.Last
10       insert into t1 values ObjectTable$(x) ;
11       end;
12 /

http://lbd.epfl.ch/f/teaching/courses/oracle9i/appdev.920/a96624/05_colls.htm#23723