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 * from actors where name like 'Wil%';

NAME
--------------------------------------------------------------------------------
WEBSITE
--------------------------------------------------------------------------------
Wil Wheaton
http://meltingpot.fortunecity.com/belgium/49/wil.htm


SQL> update actors set name='I should have died in season 1' where name='Wil Wheaton';

1 row updated.

SQL> select * from actors where name like 'I should%';

NAME
--------------------------------------------------------------------------------
WEBSITE
--------------------------------------------------------------------------------
I should have died in season 1
http://meltingpot.fortunecity.com/belgium/49/wil.htm


SQL> rollback;

Rollback complete.

SQL> select * from actors where name like 'I should%';

no rows selected

SQL> select * from actors where name like 'Wil%';

NAME
--------------------------------------------------------------------------------
WEBSITE
--------------------------------------------------------------------------------
Wil Wheaton
http://meltingpot.fortunecity.com/belgium/49/wil.htm


SQL> delete from actors;

10 rows deleted.

SQL> select count(*) from actors;

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

SQL> rollback;

Rollback complete.

SQL> select count(*) from actors;

  COUNT(*)
----------
	10

SQL> select AVG(quality) from episodes where seriesTitle='Star Trek: The Next Generation';

AVG(QUALITY)
------------
	6.75

SQL> update episodes set quality=10 where seriesTitle='Star Trek: The Next Generation';

8 rows updated.

SQL> select AVG(quality) from episodes where seriesTitle='Star Trek: The Next Generation';

AVG(QUALITY)
------------
	  10

SQL> commit;

Commit complete.

SQL> select AVG(quality) from episodes where seriesTitle='Star Trek: The Next Generation';

AVG(QUALITY)
------------
	  10

SQL> rollback;

Rollback complete.

SQL> select AVG(quality) from episodes;

AVG(QUALITY)
------------
	  10

SQL> select count(*) from episodes;

  COUNT(*)
----------
	 8

SQL> delete from episodes where season <= 1;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select count(*) from episodes;

  COUNT(*)
----------
	 7

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
1:23pm elaine25:~/cs145/ctlfiles>