You are previewing Oracle9i™ Development by Example.
O'Reilly logo
Oracle9i™ Development by Example

Book Description

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.

Table of Contents

  1. Copyright
  2. Foreword
  3. About the Author
  4. Acknowledgments
  5. Tell Us What You Think!
  6. Introduction
  7. Learning the Oracle9i Basics
    1. Introduction to Oracle9i
      1. Oracle—A Relational Database
      2. Introduction to SQL
      3. Oracle9i Features
      4. Introduction to Oracle Tools
      5. Reviewing It
      6. Checking It
      7. What's Next?
    2. Fundamentals of the SQL Language
      1. SQL Language Basics
      2. Log In to the Database
      3. The SQL Editor
      4. Introduction to SQL
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
    3. Fundamentals of PL/SQL
      1. What Is PL/SQL and Why Should I Use It?
      2. PL/SQL Basic Syntax
      3. Debugging PL/SQL
      4. Error Handling in PL/SQL
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
  8. Building Oracle9i-Based Applications
    1. Building an Oracle9i Database
      1. Relational Schema Design and Database Construction
      2. Building the Sample Application Database
      3. Summary
      4. Reviewing It
      5. Checking It
      6. Applying It
      7. What's Next?
    2. Building Oracle Forms
      1. Building Forms Using Developer 6.0 or 6.i
      2. Converting Forms to HTML
      3. Summary
      4. Reviewing It
      5. Checking It
      6. Applying It
      7. What's Next?
    3. Building Oracle Reports
      1. Building Reports Using Developer 6.0 or 6i
      2. Building Reports Using Oracle SQL*Plus
      3. Converting Reports to HTML
      4. Setting Up Windows Icons
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
    4. Using Advanced SQL Techniques and SQL*Plus Reporting Features
      1. Advanced SQL Techniques
      2. Table Join Conditions
      3. SQL Subqueries
      4. Advanced SQL*Plus Reporting Features Techniques
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
    5. Building Web Sites with Oracle9i
      1. Planning a Web Site—Buy a Car
      2. What Is Oracle9iAS?
      3. Web-Based Strategies
      4. Summary
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
    6. Using PL/SQL to Build Web Sites
      1. Using PL/SQL
      2. Building the Web Site
      3. Summary
      4. Reviewing It
      5. Checking It
      6. Applying It
      7. What's Next?
    7. Using Java to Build Web Sites
      1. What Is Java VM?
      2. Java Development Tools
      3. Using Java
      4. Building the Web Site with Java
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
    8. Using PL/SQL Pages, Java Pages, and XML with Apache/Oracle9iAS
      1. Oracle9iAS/Apache Web Server Setup Options
      2. Using PL/SQL Pages
      3. Using Java Pages
      4. Using XML
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
    9. Using Portal v3.0 (WebDB) Web Development Software
      1. What Is Portal v3.0/WebDB?
      2. Using Portal v3.0 to Build Applications
      3. Creating a Portal v3.0 Application
      4. Summary
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
  9. Oracle9i Tuning Issues
    1. Oracle9i Indexing Options
      1. Understanding Indexes
      2. B-Tree Indexes
      3. IOT Overview
      4. Implementing IOTs into Existing Applications
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
    2. Oracle9i Application SQL Tuning
      1. What Is the SQL Explain Plan?
      2. Using Stored Outlines
      3. Helpful INIT.ORA Parameters
      4. SQL Coding Guidelines
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
    3. Oracle9i Partitioning Features
      1. What Is Partitioning?
      2. Oracle9i Partitioning Options
      3. Range Partitioning
      4. Hash Partitioning
      5. Composite Partitioning
      6. List Partitioning
      7. Oracle9i Index Partitioning Options
      8. Summary
      9. Reviewing It
      10. Checking It
      11. What's Next?
  10. Working with Oracle9i Tools and Utilities
    1. Using TOAD in the Development Arena
      1. The History of TOAD
      2. Using the Main TOAD Interface
      3. Building SQL and PL/SQL Using TOAD
      4. Using the PL/SQL Debugger
      5. Using Other TOAD Utilities
      6. Summary
      7. Reviewing It
      8. Checking It
      9. Applying It
      10. What's Next?
    2. Using SQL*Loader, External Tables, and Export/Import
      1. What Is SQL*Loader
      2. What Are External Tables
      3. Using Export and Import
      4. Summary
      5. Reviewing It
      6. Checking It
      7. Applying It
      8. What's Next?
    3. Using Log Miner
      1. What Is Log Miner
      2. Using the Log Miner Interface
      3. Practical Uses for Log Miner
      4. Oracle9i Enhancements
      5. Summary
      6. Reviewing It
      7. Checking It
      8. Applying It
      9. What's Next?
  11. Putting It All Together
    1. Putting It All Together: A Sales Tracking Application
      1. Application Concepts
      2. The Sales Tracking Application
      3. Book Summary
  12. Appendixes
    1. Answers to Quizzes
      1. Answers to Chapter 1
      2. Answers to Chapter 2
      3. Answers to Chapter 3
      4. Answers to Chapter 4
      5. Answers to Chapter 5
      6. Answers to Chapter 6
      7. Answers to Chapter 7
      8. Answers to Chapter 8
      9. Answers to Chapter 9
      10. Answers to Chapter 10
      11. Answers to Chapter 11
      12. Answers to Chapter 12
      13. Answers to Chapter 13
      14. Answers to Chapter 14
      15. Answers to Chapter 15
      16. Answers to Chapter 16
      17. Answers to Chapter 17
      18. Answers to Chapter 18
    2. Oracle9i Architecture and Complete Sales Tracking Installation Scripts
      1. Oracle9i Architecture
      2. Sales Tracking Database Setup Script
      3. Sales Tracking Object Setup Script
      4. Chapter 11 Objects Setup Script
      5. Chapter 11 Java Beans Programs
    3. Software Web Sites
  13. Glossary