Chapter 1: Information about Application Development This chapter provides a road map that enables you to determine where to find information about specific application development topics, both in this Guide and in other Oracle technical publications.
Chapter 2: The Application Developer This chapter provides an overview of the Oracle Server application development process.
Chapter 3: Processing SQL and PL/SQL Statements This chapter explains the steps that the Oracle Server performs to process the various types of SQL commands and PL/SQL statements.
Chapter 4: Managing Schema Objects This chapter describes how to manage the objects that can be created in the database domain of a specific user (schema), including tables, views, numeric sequences, and synonyms. Performance enhancements to data retrieval through the use of indexes and clusters are also discussed.
Chapter 5: Selecting a Datatype This chapter describes how to choose the correct Oracle datatype. The datatypes described include fixed- and variable-length character strings, numeric data, dates, and binary large objects.
Chapter 6: Maintaining Data Integrity This chapter describes how to use declarative integrity constraints to provide data integrity within an Oracle database.
Chapter 7: Using Procedures and Packages This chapter describes how to create procedures that can be stored in the database for continued use. Grouping these procedures into packages is also described.
Chapter 8: PL/SQL Input and Output This chapter describes how to use public and private pipes to allow sessions in the same instance to communicate with one another.
Chapter 9: Using Database Triggers This chapter describes how to create and debug database triggers. Numerous examples are included.
Chapter 10: Using Dynamic SQL This chapter describes how you can write stored procedures and anonymous PL/SQL blocks using dynamic SQL.
Chapter 11: Managing Dependencies Among Schema Objects This chapter describes how to manage the dependencies between related views, procedures, packages, and triggers.
Chapter 12: Signalling Events in the Database with Alerters This chapter describes how you can design your application to be notified whenever values in the database that are of interest to the application are changed.
Chapter 13: Establishing a Security Policy This chapter describes how to design a security policy using Oracle's security features.