Add more rows to EMP30 table with employee in department 40. Do not transfer employee’s salary.
Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)
```
SQL> INSERT INTO emp30 (EmployeeId, Lname, Fname, HireDate)
2 SELECT EmployeeId, Lname, Fname, HireDate
3 FROM employee
4 WHERE DeptId = 40;
1 row created.
SQL> SELECT * FROM emp30;
EMPLOYEEID LNAME FNAME HIREDATE SALARY
---------- --------------- --------------- --------- ----------
200 Shaw Jinku 03-JAN-00 24500
135 Garner Stanley 29-FEB-96 45000
246 Houston Larry 19-MAY-67
```
You might also like to view...
A(n) ________ is the intersection of a row and a column
Fill in the blank(s) with correct word
If workbook A is linked to workbook B, workbook A must be closed when shared copies of workbook B are created in order to prevent the references in workbook A from being automatically changed to reference the new files
Indicate whether the statement is true or false.