Oracle 通过子查询批量添加、修改表数据

create table test1(id,job,mgr,sal)
as
(select * from  (select rownum rn,a.JOB,a.MGR,a.SAL from emp a where rownum<=10)  where rn>=6)   ---这是一个分页查询

create or replace view V_test1
as
(select * from  (select rownum rn,a.JOB,a.MGR,a.SAL from emp a where rownum<=10)  where rn>=6)   ---这是一个分页查询

create table test2(id varchar2(100),mgr number(4),sal number(7,2))  --创建一张表test2
insert into test2 
select * from (select rownum rn,a.* from (select MGR,SAL from emp) a where rownum<=10)  where rn>=6   

update emp set (job,sal,comm)=
(select job,sal,comm from emp where ename='SMITH')
where ename='SCOTT'

select job,sal,comm from emp where ename in ('SMITH','SCOTT')