How do we do mass updates in Oracle PL SQL?

shivigupta

 Profile Answers by shivigupta Questions by shivigupta

• Oct 9th, 2012

Code
declare
type id_table IS TABLE of testemp.emp_id%type;
 v_id_table id_table;
 
 begin 
 UPDATE testemp SET subject = d1 WHERE emp_id = 1
 returning emp_id bulk collect INTO v_id_table;
 
 commit;
 dbms_output.put_line(count IS:==||v_id_table.count);
 end;

GeekQA123

 Profile Answers by GeekQA123 Questions by GeekQA123

• Aug 15th, 2012

Use Bulk Update stmt.

Answer Question  Select Best Answer