insert all
into test1 values(no,name)
into test2 values(no,sal)
select empno no,ename name,sal from scott.emp;