create tbale teacher
as
select empno,ename,sal from emp;
create table t1
as
select empno,ename from teacher where 1=2;
create table t2
as
select empno,sal from teacher where 1=2;
insert all
into t1 values (empno,ename)
into t2 values (empno,sal)
select empno,ename,sal from teacher;
insert all
when empno < 7800 then into t1 values (empno,ename)
when empno > 7800 then into t2 values (empno,sal)
select empno,ename,sal from teacher;
insert first
when empno < 7800 then into t1 values (empno,ename)
when empno > 7800 then into t2 values (empno,sal)
elect * from teacher;