Why is the GETDATE() an invalid identifier
function, oracle, triggers
Solution
I think you want `SYSDATE`, not `GETDATE()`. Try it:
UPDATE TableName SET LastModifiedDate = (SELECT SYSDATE FROM DUAL);
Problem
Why is the GETDATE() an invalid identifier says Oracle Sql Developer tool when I debug this code: ``` CREATE OR REPLACE TRIGGER SPName AFTER UPDATE ON TableName FOR EACH ROW BEGIN UPDATE TableName SET LastModifiedDate = GETDATE() WHERE TableName.DET_ID = :new.DET_ID; END; ```