Any replacement of variable "v_curr_salary"
Dear 365datascience team,
Since I can't find any differences in the output of replacing the variable "v_curr_salary" with "NEW.emp_no"
in the "IF" clause, is it a good idea to use "NEW.emp_no" instead of "v_curr_salary"?
What about "NEW.from_date" & "NEW.to_date"?
I would need your help of some explaination here.
Thank you!
1 answers ( 0 marked as helpful)
Hi Chun!
Thanks for reaching out.
Theoretically, you can use it but since you provide values to these columns it does not make much sense to check if they are not null. Please, stick to the provided solution.
Hope this helps.
Best,
Tsvetelin
