Database Systems using Oracle
A Simplified Guide to SQL and PL/SQL
2nd Ed.

Nilesh Shah,
Pearson Education International, 2005
ISBN 0-13-101857-4

Chapter   7 : pp. 156 - 171
Chapter   8 : pp. 173 - 178, 181 - 187
Chapter   9 : pp. 191 - 194, 204 - 207
Chapter 12 : pp. 267 - 288
Chapter 13 : 296 -300
Chapter 14 : 313 - 323, 328 - 334

Please note that chapters 1-6 is considered basic knowledge.
Also chapters 10-11, and "PL/SQL in a hurry..." is considered known material.