Objective : Update should be done on all records in a custom's table i.e., zempinfo with the provided condition
Hint :
zempinfo table consists the following fields
1) empno
2) empname
3) deptno
4) depname
Now, I want to change deptno = 20 for those whose empname starts with 'P'
Try to explain with example if possible......!
Best Answers can be Rewarded......!