I am trying to create a trigger: create or replace trigger NAME_OF_TRIGGER after insert or update on table1
Simple one. I´m a bit of a newvbie with PLSql and oracle\'s error messages are never too helpful. I want to do a simple trigger to update a column with the current date i.e. \'modified date\' column
My tables: TableA (id number, state number) TableB (id number, tableAId number, state number) TableC (id number, tableBId number, state number)