Oracle 8: The Complete Reference - A good general reference on Oracle.
Oracle PL/SQL Programming - Detailed tutorial and reference on PL/SQL programming.
Tim Hartley's homepage - Including neat set of scripts to examine Oracle catalog.
Sunil Kumar's scripts - Including a nice script to trace foreign keys of a table.