This chapter is from the book
This chapter is from the book
This chapter is from the book
Chapter 2: Test Your Thinking
The projects in this section are meant to have you utilize all of the skills that you have acquired throughout this chapter. The answers to these projects can be found at the companion Web site to this book, located at http://authors.phptr.com/rischert3e. Visit the Web site periodically to share and discuss your answers.
-
Invoke an editor from SQL*Plus; create a file called first.sql containing an SQL statement that retrieves data from the course table for courses that cost 1195, and whose descriptions start with 'Intro', sorted by their prerequisites.
-
Create another file called second.sql that retrieves data from the student table for students whose last names begin with 'A', 'B', or 'C', and who work for 'Competrol Real Estate', sorted by their last names.
-
Create yet another file called third.sql that retrieves all the descriptions from the grade_type table, for rows that were modified by the user MCAFFREY.
-
Execute each of the files, in the order they were created.