Oracle Mass Update

How do we do mass updates in Oracle PL SQL?

Questions by galactus911

Showing Answers 1 - 3 of 3 Answers

Code
  1. declare

  2. type id_table IS TABLE of testemp.emp_id%type;

  3.  v_id_table id_table;

  4.  

  5.  begin

  6.  UPDATE testemp SET subject = d1 WHERE emp_id = 1

  7.  returning emp_id bulk collect INTO v_id_table;

  8.  

  9.  commit;

  10.  dbms_output.put_line(count IS:==||v_id_table.count);

  11.  end;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions