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> select count(*) from characters where (name, characters.seriesTitle, characters.seriesCreator) NOT IN (select characterName, seriesTitle, seriesCreator FROM featuring);

  COUNT(*)
----------
       179

SQL>
SQL> select count(*) from plays where (characterName, plays.seriesTitle, plays.seriesCreator) NOT IN (select characterName, seriesTitle, seriesCreator FROM featuring);

  COUNT(*)
----------
       179

SQL> @plsql2 @plsql2 
  1  DECLARE
  2  	n characters.name%TYPE;
  3  	st characters.seriesTitle%TYPE;
  4  	sc characters.seriesCreator%TYPE;
  5
  6  	CURSOR T1Cursor IS
  7  	SELECT DISTINCT characters.name, characters.seriesTitle,
  8  		characters.seriesCreator FROM characters,featuring where (characters.name,
  9  		characters.seriesTitle, characters.seriesCreator) NOT IN (select
 10  		characterName, seriesTitle, seriesCreator from featuring);
 11  BEGIN
 12  	OPEN T1Cursor;
 13  	LOOP
 14  		FETCH T1Cursor INTO n, st, sc;
 15  		EXIT WHEN T1Cursor%NOTFOUND;
 16  		DELETE FROM plays WHERE characterName = n
 17  			AND seriesTitle = st
 18  			AND seriesCreator = sc;
 19  		DELETE FROM characters WHERE name = n
 20  			AND seriesTitle = st
 21  			AND seriesCreator = sc;
 22  	END LOOP;
 23  	CLOSE T1Cursor;
 24
 25* END;

PL/SQL procedure successfully completed.

SQL> select count(*) from characters where (name, characters.seriesTitle, characters.seriesCreator) NOT IN (select characterName, seriesTitle, seriesCreator FROM featuring);

  COUNT(*)
----------
	 0

SQL> select count(*) from plays where (characterName, plays.seriesTitle, plays.seriesCreator) NOT IN (select characterName, seriesTitle, seriesCreator FROM featuring);

  COUNT(*)
----------
	 0

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
2:04pm elaine11:~/cs145/hw5>