Amit Sinha

Sample Query DECLARE TYPE updatedId IS TABLE OF Table1.col2%TYPE; XupdatedId updatedId; BEGIN UPDATE TABLE1 SET col1 = 'OK' WHERE col2 IN ('abc','def') RETURNING col2 BULK COLLECT INTO XupdatedId; END; Here...