462.sql

来自「Oracle 9i中文版基础培训教程」· SQL 代码 · 共 5 行

insert into scott.emp(empno,ename,hiredate)
     (select empno+100,ename,hiredate  from scott.emp
     where empno>=6999
     );