Sample Chapter

Topics

Place an Order

Home

Related Links

Learning Oracle Database Programming

Chapter 1: Roles and System Privileges

• System Privileges
• Roles
• User Privileges
• Creating Roles
• Setting Default Roles
• Enabling Roles

Chapter 2: Creating Tables, Part 1

• Tablespaces and Extents
• The Primary Key
• Constraints
• Testing Constraints
• Indexes Supporting Constraints
• Column Information
• Saving Your Work

Chapter 3: Altering Tables: Adding Columns and Constraints

• Adding Columns to a Table
• Adding NOT NULL Constraints
• The Exceptions Table
• Unique indexes

Chapter 4: Sequences and Comments

• Sequences
• Comments on Tables and Columns

Chapter 5: Triggers and Packages

• Triggers
• Creating a Package
• Avoiding Unnecessary Compilatio
• Locating Errors
• The Package Body
• Errors and Exception Handlers
• Testing the Package
• Creating a Trigger
• Data Dictionary Views
• Altering a Trigger

Chapter 6: Referential Integrity

• Defining Integrity Relationships
• Creating a Referential Integrity Constrain
• Testing Constraints
• Cascading Deletes
• Dropping an Index With Dependencies

Chapter 7: Creating Tables, Part 2

• Compound Foreign Keys
• Adding a Unique Constraint
• Trigger When Clause
• Multiple Triggers for a Single Event
• The Long Datatype
• Default Column Values
• Compound Primary Keys
• Retrieving Multiple Rows as One Row
• For Each Statement Triggers

Chapter 8: Session Variables

• Declarations and Initialization
• User-Defined Exceptions
• Calling Functions in SQL Statements

Chapter 9: A Transaction

• Oracle Transactions
• A Stored Function
• Parameters and Default Values
• The Start of a Transaction and Savepoints
• Cursors and Cursor Attributes
• Rollback to Savepoint
• Describing Stored Programs
• Testing the Transaction

Chapter 10: Mutating Tables

• For Each Row Trigger Rules
• PL/SQL Tables
• After Insert Statement Trigger

Chapter 11: Cursors and PL/SQL Tables

• Loading PL/SQL Tables
• Cursor For Loops
• Searching For a Value In a PL/SQL Table
• Cursor Parameters
• Public User-Defined Exceptions
• Shared SQL
• Public Cursors and Procedure Overloading
• Datatype Families

Chapter 12: Roles and Object Privileges

• Granting Object Privileges
• Creating Synonyms
• Using the DBMS_SQL Package

Appendix A: Basic Data Modeling With ERA

• Data Modeling
• Data Structures and Procedures
• The ERA Process
• Getting Started
• Step 1: Discover the Entities
• Find the Primary Key
• Step 2: Discover the Relations
• Step 3: Discover the Attributes
• Advanced Data Modeling
• Scope of ERA