463.sql

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

create table  scott.test
 as
  (
   select distinct empno,ename,hiredate
   from scott.emp
   where empno>=7000
   );