difference between regular update and update with execute immediate
588400Apr 22 2009 — edited Apr 23 2009Hi everyone, I have seen some code where developers have executed insert and update statement using execute immediate.
for example :
execute immediate ('Update employees set employee_salary = :x');
I can update record using the following statement where x is a number (salary)
update employee
set employee_salary = x;
It works fine as well
Whats the difference? and what way is recommended
Thanks