Create a SQL script file that will

a) Create a view that will display the names of courses taught by Anita Morris
b) Display that data from the view.

You should be able to run the script from the SQL*Plus command line with the @ symbol or the "run" command

```
CREATE OR REPLACE VIEW v_morris AS
SELECT course_no, description
FROM course c
WHERE EXISTS (SELECT null
FROM section s, instructor i
WHERE s.instructor_id = i.instructor_id
AND c.course_no = s.course_no
AND last_name = 'Morris'
AND first_name = 'Anita')

SELECT *
FROM v_morris
```

Computer Science & Information Technology

You might also like to view...

________ is an Internet-based tool which lets you make recipes that automate tasks like silencing your phone when you go into class

Fill in the blank(s) with correct word

Computer Science & Information Technology

Another name for a repair installation is which of the following?

a. OS replacement. b. Custom installation. c. In-place upgrade. d. Multiboot installation.

Computer Science & Information Technology