Updating current record oracle


CREATE or REPLACE TRIGGER emp_after_insert AFTER INSERT ON emp FOR EACH ROW DECLARE BEGIN insert into emp_backup values (:new.empid, :new.fname, :new.lname); DBMS_OUTPUT.

PUT_LINE('Record successfully inserted into emp_backup table'); END; Second Problem: We want o update a record in the ’emp_backup’ table if a corresponding record is updated in the ’emp’ table.

The functionality supports the following use case: page after an unsuccessful attempt to save.

The cases are distinguished by the Server Request method through which the data is transferred.

Now you need to update the input form so that it can be also used for both cases.