1 2 Previous Next 23 Replies Latest reply: Oct 9, 2013 5:07 PM by Sven W. RSS

    Using insert and delete at the same time

    tennek

      Good afternoon,

       

      i want to do an insert from table A into table B, while at the same time do a delete on table A

      and i want to do it with out procedures.

       

      here is the script i came up with,

       

      INSERT into table_a (select * from table_b where status = 'D') DELETE from table_b where status = 'D'

       

      but i get an ORA-00933 error.

       

      Got any ideas on how i can do this??

       

      thank you

        1 2 Previous Next