Beginning Oracle Programming

- Getting to Know Oracle
- SQL*PLUS and Basic Querying
- Creating and Managing Users and Tables
- The 9i Sample Schemas
- Architecture
- Processing Statements in Oracle
- Tables
- Indexes
- Mastering SQL*PLUS
- PL/SQL
- Procedures, Functions and Packages
- Transactions and Concurrency
- Security
- Views
- Triggers
- Objects
- Advanced Querying
- Tuning Tools
- A SQL Toolkit
- Case Study 1: Debugging PL/SQL
- Case Study 2: Finding People
- Appendix A: SQL Function Reference
- Appendix B: Supplied Packages
- Appendix C: Data Dictionary
- Appendix D: Installing Sample Schemas
- Appendix E: Options and Features.

Sean Dillon: Sean Dillon started programming a Commodore Vic 20 back in 1980 at the age of nine. Sean grew and so did his love for programming. He began his professional programming career in the United States Marine Corps, shortly after returning from the Gulf War. Sean is now a Principal Technologist, working for Oracle Corporation based in Reston, Virginia. He has ten years of experience specializing in database architecture, database tuning, web application development, XML, and Web Services technologies.

Christopher Beck: Christopher Beck has a bachelor’s degree in Computer Science from Rutgers University. He has worked in the industry for 11 years. Starting off as a junior Ada software developer for a government systems integrator, he has spent the last seven years with Oracle Corporation and is now a Principal Technologist there. He specializes in core database technologies and web application development. WebView, a "science project" that he and a colleague wrote, has now become the commercial product known as Oracle Portal.

Thomas Kyte: Thomas Kyte is the Vice President of the Core Technologies Group at Oracle Corporation. He has been working for Oracle since version 7.0.9 (that's 1993 for people who don't mark time by Oracle versions). However, he has been working with Oracle since about version 5.1.5c. Before coming to work at Oracle, Thomas worked for more than six years as a systems integrator building large scale, heterogeneous databases and applications, mostly for military and government customers. These days, he spends a great deal of time working with the Oracle database and, more specifically, helping people who are using the Oracle database. He works directly with customers, either in specifying and building their systems or, more frequently, helping them rebuild or tune them ('tuning' frequently being a synonym for rebuilding). In addition, he is the Tom behind 'AskTom' in Oracle Magazine, answering people's questions about the