insert 另外一种用法

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;
原文地址:https://www.cnblogs.com/tianmingt/p/4085650.html