Resolved: Local Variables Question
why does this change from v_avg_salary to v_avg_salary_2 produce an errror?
Thanks for reaching out.
It is because we declared the v_avg_salary_2 variable in another BEGIN-END block. Thus, this variable is undeclared in the main BEGIN-END block and Workbench gives us the error message that states this variable is undeclared.
Hope this helps.