insert first when deptno=10 then into dept01(id) values(deptno) when deptno=20 then into dept02(id) values(deptno) else into dept03(id) values(deptno) select deptno from emp;
insert first when deptno=10 then into dept01(id) values(deptno) when deptno=20 then into dept02(id) values(deptno) else into dept03(id) values(deptno) select deptno from emp;