Last answered:

29 May 2023

Posted on:

26 May 2023


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)
Posted on:

29 May 2023


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.

Submit an answer