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

Computer Science & Information Technology

You might also like to view...

List three things that diagnosing problems with LAN technologies requires.

What will be an ideal response?

Computer Science & Information Technology

What is the return value of "SELECT".substring(4, 4)?

a. an empty string b. C c. T d. E

Computer Science & Information Technology

What are the two main differences between a heap and a binary search tree?

What will be an ideal response?

Computer Science & Information Technology

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

Computer Science & Information Technology