Delete rows from SP03SECT table for faculty Mobley.
Use the Indo–US College database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP2.LST file)
```
SQL> DELETE FROM sp03sect
2 WHERE FacultyId =
3 (SELECT FacultyId
4 FROM faculty
5 WHERE UPPER(Name) = 'MOBLEY');
2 rows deleted.
SQL> SELECT * FROM sp03sect;
COURSE SE FACULTYID ROOMID
------ -- ---------- ----------
CIS265 01 14
CIS265 02 111 18
LA123 05 15
CIS253 11 111 18
```
You might also like to view...
The ________ window in OpenOffice Base is used to create or modify a table's design
Fill in the blank(s) with correct word
You are redesigning an existing RISC?style pipelined processor to make it a three?way superscalar processor that permits three instructions to be executed at the same time.
a. Do you expect the new processor to achieve three instructions per clock? b. What level of design complexity do you expect the new processor to have in comparison with the pipelined version?