Last answered:

29 May 2023

Posted on:

26 May 2023

0

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

29 May 2023

1

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

Submit an answer