Unanswered: updating old table from new with cursor
I want to compare table OLD with table NEW . If two fields of table NEW are equal to table OLD then i need to update the remaining fields of table OLD with table NEW values.OTHER WISE I NEED TO INSERT I am trying to do this by this code . It is updating but while inserting it giving error as
oldname must be declared so how i can call 2nd cursor in this , is there any other solution for this.
CURSOR OLDCUR IS SELECT * FROM OLD;
CURSOR NEWCUR IS SELECT * FROM NEW;
UPD NUMBER:= 0 ;