Skip to Content
0
Former Member
Jun 02, 2008 at 04:40 AM

To change Mulitple Records value..............!

40 Views

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......!