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 另外一种用法
原文：http://www.cnblogs.com/tianmingt/p/4085650.html
