Don't understand the use of the term "New"
Why we use the term New.hire_date instead of referring to this with a diff name
I feel like we have two columns with the same name, and we differentiate between them by using the term "New"
1 answers ( 0 marked as helpful)
Hi Elmehdi!
Thanks for reaching out.
The NEW
keyword is a pseudo-record name that refers to the new table row for insert and update operations in row-level triggers. Its usage is: NEW.column
, where column is the name of a column in the table on which the trigger is defined.
Hope this helps.
Best,
Tsvetelin