KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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;
Tags (comma-separated)
Save Edits
Cancel