ORACLE PL/SQL 101

Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

Part I: Dabase Basics. Chapter 1: Introduction to Databases. Chapter 2: Storing and Retrieving Data: The Basics. Chapter 3: Advanced Data Manipulation. Chapter 4: Controlling SQL Plus. Part II: Advanced SQL. Chapter 5: SQL Functions. Chapter 6: Using Indexes and Constraints. Chapter 7: Other Useful Oracle Techniques. Part III: Creating Programs Using PL/SQL. Chapter 8: Introduction to PL/SQL. Chapter 9: More PL/SQL Tools. Part IV: Appendix. Glossary. Index.