Skip to Main Content

Using insert and delete at the same time

tennekOct 9 2013 — edited Oct 9 2013

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

Post Details
Added on Oct 9 2013