462.sql

Oracle 9i中文版基础培训教程

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