Script started on Thu Sep  6 18:03:18 2001
[holmes Misc]$ sqlplus

SQL*Plus: Release 8.0.6.0.0 - Production on Thu Sep 6 18:03:23 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter user-name: sc42405
Enter password: 

Connected to:
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Objects option
PL/SQL Release 8.0.6.0.0 - Production

SQL> set echo on
SQL> start homework1o.sql
SQL> CREATE TABLE CDs (
  2  	     author VARCHAR(30),
  3  	     title VARCHAR(50),
  4  	     year SMALLINT,
  5  	     company VARCHAR(50),
  6  	     rating SMALLINT
  7  		     CHECK (rating >=0 and rating <= 10),
  8  	     list_price NUMBER(7, 2),
  9  	     actual_price NUMBER(7, 2)
 10  );

Table created.

SQL> 
SQL> INSERT INTO CDs VALUES (
  2  	     'Barenaked Ladies', 'Rock Spectacle', 1996, 'Reprise Records', 8, 20.00, 15.99
  3  );

1 row created.

SQL> 
SQL> INSERT INTO CDs VALUES (
  2  	     'U2', 'All that you can''t leave behind', 2000, 'Universal International Music',
  3  	     8, 22.00, 16.99
  4  );

1 row created.

SQL> 
SQL> INSERT INTO CDs VALUES (
  2  	     'Grant Lee Philips', 'Mobilize', 2001, 'Zoe Records', 9, 20.00, 20.00
  3  );

1 row created.

SQL> 
SQL> INSERT INTO CDs VALUES (
  2  	     'ABBA', 'Greatest Hits', 1992, 'Polygram Records', 9, 20.00, 10.99
  3  );

1 row created.

SQL> 
SQL> INSERT INTO CDs VALUES (
  2  	     'Author2000', 'Title2000', 2000, 'Company2000', 2, 2000.00, 0.20
  3  );

1 row created.

SQL> 
SQL> SELECT title, author FROM CDs WHERE year = 2000;

TITLE
--------------------------------------------------
AUTHOR
------------------------------
All that you can't leave behind
U2

Title2000
Author2000


SQL> 
SQL> DROP TABLE CDs;

Table dropped.

SQL> 
SQL> quit
Disconnected from Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Objects option
PL/SQL Release 8.0.6.0.0 - Production
[holmes Misc]$ exit

script done on Thu Sep  6 18:04:17 2001