SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

This post has been answered by Mike Kutz on Oct 9 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2013

Added on Oct 9 2013

#delete, #insert, #select

23 comments

4,598 views