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...
List three things that diagnosing problems with LAN technologies requires.
What will be an ideal response?
What is the return value of "SELECT".substring(4, 4)?
a. an empty string b. C c. T d. E
What are the two main differences between a heap and a binary search tree?
What will be an ideal response?
In a user needs assessment project, an analyst develops a model of the proposed new technology and makes a build-versus-buy recommendation during which of these phases?
A. Preparation B. Investigation C. Decision D. None of these