rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Nov 24th, 2008

 

use package  for mass update.

GeekQA123

 Profile Answers by GeekQA123 

• Aug 15th, 2012

 

Use Bulk Update stmt.

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;