Oracle7 Server Application Developer's Guide

• Oracle7^(tm) Server Application Developer's Guide

• Preface
  • Information in this Guide
  • How this Guide Is Organized
  • Notational Conventions
  • Your Comments Are Welcome

• Information About Application Development
  • Sources of Information
  • Specific Topics

• The Application Developer
  • Assessing Needs
  • Designing the Database
  • Designing the Application
  • Writing SQL
  • Enforcing Security in Your Application
  • Tuning an Application
  • Maintaining and Updating an Application

• Processing SQL Statements
  • SQL Statement Execution
  • Controlling Transactions
  • Read-Only Transactions
  • The Use of Cursors
  • Explicit Data Locking
  • Explicitly Acquiring Row Locks
  • SERIALIZABLE and ROW_LOCKING Parameters
  • Creating User Locks
  • Sample User Locks
  • Viewing and Monitoring Locks
  • Concurrency Control Using Serializable Transactions

• Managing Schema Objects
  • Managing Tables
  • Managing Views
  • Modifying a Join View
  • Managing Sequences
  • Managing Synonyms
  • Managing Indexes
  • Managing Clusters, Clustered Tables, and Cluster Indexes
  • Managing Hash Clusters and Clustered Tables
  • Miscellaneous Management Topics for Schema Objects
  • Listing Information about Schema Objects

• Selecting a Datatype
  • Oracle Datatypes
  • Trusted Oracle MLSLABEL Datatype
  • Trusted Oracle ROWLABEL Column
  • Displaying Your DBMS Label
  • Altering Your DBMS Label
  • ANSI/ISO, DB2, and SQL/DS Datatypes
  • Data Conversion
  • Data Conversion for Trusted Oracle
  • Formatting Labels
  • Comparing Labels
  • Guidelines for Defining Labels

• Maintaining Data Integrity
  • Using Integrity Constraints
  • Using Referential Integrity Constraints
  • Referential Integrity in a Distributed Database
  • Using CHECK Integrity Constraints
  • Defining Integrity Constraints
  • Enabling and Disabling Integrity Constraints
  • Altering Integrity Constraints
  • Dropping Integrity Constraints
  • Managing FOREIGN KEY Integrity Constraints
  • Listing Integrity Constraint Definitions

• Using Procedures and Packages
  • PL/SQL
  • Packages
  • Timestamps and Signatures
  • Cursor Variables
  • Hiding PL/SQL Code
  • Error Handling
  • Invoking Stored Procedures
  • Calling Stored Functions from SQL Expressions
  • Supplied Packages
  • Describing Stored Procedures
  • Listing Information about Procedures and Packages

• PL/SQL Input/Output
  • Database Pipes
  • Output from Stored Procedures and Triggers
  • PL/SQL File I/O

• Using Database Triggers
  • Designing Triggers
  • Creating Triggers
  • When Triggers Are Compiled
  • Debugging a Trigger
  • Modifying a Trigger
  • Enabling and Disabling Triggers
  • Listing Information About Triggers
  • Examples of Trigger Applications

• Using Dynamic SQL
  • Overview
  • Using DBMS_SQL
  • Execution Flow
  • Security
  • Procedures and Functions
  • Locating Errors
  • Examples

• Managing Dependencies Among Schema Objects
  • Dependency Issues
  • Manually Recompiling
  • Listing Dependency Management Information

• Signalling Events in the Database with Alerters
  • Overview
  • Using Alerts
  • Checking for Alerts
  • Example of Using Alerts

• Establishing a Security Policy
  • Application Security Policy
  • Managing Privileges and Roles

Copyright