Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

 
SQL> INSERT INTO episodes VALUES ('Encounter at Farpoint, Part 1',TO_DATE('09-28-1987','mm-dd-yyyy'),3,'The new U.S.S. Enterprise','http://www.startrek.com/library/media_tng.asp?id=18240',1,'Star Trek: The Next Generation','Gene Roddenberry');
 

1 row created.

 
SQL> INSERT INTO studios (name, address, website) VALUES ('Paramount','5555 Melrose Avenue, Los Angeles, CA 90038','http://www.paramount.com');
 

1 row created.

 
SQL> DELETE FROM actors WHERE name IN (select actorName from plays);
 

92 rows deleted.

 
SQL> INSERT INTO actors(name)
 SELECT DISTINCT actorName
 FROM plays
;
 

  2    3    4  
100 rows created.


 
SQL> DELETE FROM series WHERE creator = 'creator7';
 

1 row deleted.

 
SQL> INSERT INTO series(title, creator)
 SELECT DISTINCT seriesTitle, seriesCreator
 FROM episodes E1
 WHERE title='Episode 2'
 AND NOT EXISTS (
  select * from series where title = E1.seriesTitle AND creator = E1.seriesCreator
 )
;
 

  2    3    4    5    6    7    8  
1 row created.


 
SQL> DELETE FROM actors 
WHERE actors.name IN
 (SELECT actorName from plays 
  WHERE characterName IN
   (SELECT characterName from featuring
    WHERE seriesTitle = 'series12'
    AND seriesCreator = 'creator12'
   )
 )
;
 


  2    3    4    5    6    7    8    9   10  
8 rows deleted.


 
SQL> UPDATE series 
SET website='http://tv.com',
 startdate=TO_DATE('01-01-1999','mm-dd-yyyy'), 
 enddate=TO_DATE('01-01-2999','mm-dd-yyyy')
WHERE title = 'series7';
 


  2    3    4    5  
1 row updated.


 
SQL> UPDATE episodes
SET quality = 10
WHERE title IN
 (SELECT episodeTitle from featuring 
  WHERE characterName LIKE 'character9_'
  AND seriesCreator = 'creator12'
 )
;
 

  2    3    4    5    6    7    8  
5 rows updated.

SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
11:06pm elaine31:~/cs145>