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
```

Computer Science & Information Technology

You might also like to view...

In order, the three-step process of using a file in a C++ program involves

a. insert a disk, open the file, remove the disk b. create the file contents, close the file, name the file c. open the file, read/write/save data, close the file d. name the file, open the file, delete the file e. None of these

Computer Science & Information Technology

The first successful commercial personal computer was the ______ in 1976.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Explain why the RS232 asynchronous serial interface was probably the worst misfortune to befall early personal computers.

What will be an ideal response?

Computer Science & Information Technology

Explain how to use an array literal to declare an array.

What will be an ideal response?

Computer Science & Information Technology