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


      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