insert

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;