0
deptno = 20 where emp_id is divisible by 2
Set the value of deptno in the following order deptno = 20 where emp_id is divisible by 2 deptno = 30 where emp_id is divisible by 3 deptno = 40 where emp_id is divisible by 4 deptno = 50 where emp_id is divisible by 5 deptno = 10 for the remaining records.
1 Answer