title: Why is the GETDATE() an invalid identifier
body: <p>Why is the GETDATE() an invalid identifier says Oracle Sql Developer tool when I debug this code:</p>
  
  <pre><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;
  </code></pre>