/* please temporarily create a test environment
Create a new table:
- required to take out the emp table salary information in more than 3000 workers in the new department
And appointed wage level of the highest staff manager
New employees to get Numbers from the sequence again; */

CodePudding user response:

Through the way of CTS to create
The create table tab_emp as
The select nextval. Seq_emp EMPNO,
ENAME,
JOB,
(select Max (ename) from emp where sal> 3000) MGR,
HIREDATE,
SAL,
COMM,
DEPTNO,
The from emp
Where sal> 3000;

CodePudding user response:

Thank you for your class!