This content has been marked as final. Show 4 replies
Whenever you have a problem, please post a little sample data (CREATE TABLE and INSERT statements, relevant columns only) from all tables.
Also post the results you want from that data, and an explanation of how you get those results from that data, with specific examples.
If you're asking about a DML statement, such as UPDATE, the CREATE TABLE and INSERT statements should re-create the tables as they are before the DML, and the results will be the contents of the changed table(s) when everything is finished.
Always say which version of Oracle you're using.
It's unclear why you need two cursors. You can probably do everything you want to in a single MERGE statement, especially if you're using Oracle 11, where MERGE can DELETE rows.