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??