How can you tell what field has been changed in an Oracle Trigger?
and what the values were/are?

In SQL Server you can use the Deleted and Inserted tables, is there something similar in Oracle? and if so how do you access them?

Mark Anderson

CREATE OR REPLACE TRIGGER trg_ssn
   BEFORE INSERT ON Patient
   FOR EACH ROW
 BEGIN
     If (:new.ssn) is null then
        IF sysdate - :new.dob < 730 THEN
           RAISE_APPLICATION_ERROR (-20500, 'Patient must be');
        END IF;
     end if;
end trg_ssn;
/
show errors;
________________________

you use the :new operator and :old operator. Close to the same as SQL Server.
Do a search on the web for those two operators.



Sal