Oracle9i Development By Example

Dan Hotka is a Senior Technical Advisor for Quest Software. He has over 23 years in the computer industry and over 18 years experience with Oracle products. He is an acknowledged Oracle expert with Oracle experience dating back to the Oracle V4.0 days. He has authored the popular books Oracle9i Development by Example and Oracle8i from Scratch, published by Que, co-authored the popular books Oracle Unleashed, Oracle8 Server Unleashed, and Oracle Development Unleashed, by SAMS, and Special Edition Using Oracle8/8i, by Que. He is a monthly contributing editor to Oracle Professional, a Pinnacle Publication, is frequently published in trade journals, and regularly speaks at Oracle conferences and user groups around the world. Dan can be reached at dhotka@earthlink.net.

(NOTE: Each chapter concludes with Reviewing It, Checking It, and What's Next?)

Introduction.
I. LEARNING THE ORACLE9I BASICS.

1. Introduction to Oracle9i.


Oracle—A Relational Database. Introduction to SQL. Oracle9i Features. Introduction to Oracle Tools.

2. Fundamentals of the SQL Language.


SQL Language Basics. Log In to the Database. The SQL Editor. Introduction to SQL. Applying It.

3. Fundamentals of PL/SQL.


What Is PL/SQL and Why Should I Use It? PL/SQL Basic Syntax. Debugging PL/SQL. Error Handling in PL/SQL. Applying It.

II. BUILDING ORACLE9I-BASED APPLICATIONS.

4. Building an Oracle9i Database.


Relational Schema Design and Database Construction. Building the Sample Application Database. Summary. Applying It.

5. Building Oracle Forms.


Building Forms Using Developer 6.0 or 6.i. Converting Forms to HTML. Summary. Applying It.

6. Building Oracle Reports.


Building Reports Using Developer 6.0 or 6i. Building Reports Using Oracle SQL*Plus. Converting Reports to HTML. Setting Up Windows Icons. Summary. Applying It.

7. Using Advanced SQL Techniques and SQL*Plus Reporting Features.


Advanced SQL Techniques. Table Join Conditions. SQL Subqueries. Advanced SQL*Plus Reporting Features Techniques. Summary. Applying It.

8. Building Web Sites with Oracle9i.


Planning a Web Site—Buy a Car. What Is Oracle9iAS? Web-Based Strategies. Summary. Applying It.

9. Using PL/SQL to Build Web Sites.


Using PL/SQL. Building the Web Site. Summary. Applying It.

10. Using Java to Build Web Sites.


What Is Java VM? Java Development Tools. Using Java. Building the Web Site with Java. Summary. Applying It.

11.Using PL/SQL Pages, Java Pages, and XML with Apache/Oracle9iAS.


Oracle9iAS/Apache Web Server Setup Options. Using PL/SQL Pages. Using Java Pages. Using XML. Summary. Applying It.

12. Using Portal v3.0 (WebDB) Web Development Software.


What Is Portal v3.0/WebDB? Using Portal v3.0 to Build Applications. Creating a Portal v3.0 Application. Summary. Applying It.

III. ORACLE 9I TUNING ISSUES.

13. Oracle9i Indexing Options.


Understanding Indexes. B-Tree Indexes. IOT Overview. Implementing IOTs into Existing Applications. Applying It.

14. Oracle9i Application SQL Tuning.


What Is the SQL Explain Plan? Using Stored Outlines. Helpful INIT.ORA Parameters. SQL Coding Guidelines. Summary. Applying It.

15. Oracle9i Partitioning Features.


What Is Partitioning? Oracle9i Partitioning Options. Range Partitioning. Hash Partitioning. Composite Partitioning. List Partitioning. Oracle9i Index Partitioning Options. Summary.

IV. WORKING WITH ORACLE9I TOOLS AND UTILITIES.

16. Using TOAD in the Development Arena.


The History of TOAD. Using the Main TOAD Interface. Building SQL and PL/SQL Using TOAD. Using the PL/SQL Debugger. Using Other TOAD Utilities. Summary. Applying It.

17. Using SQL*Loader, External Tables, and Export/Import.


What is SQL Loader. What Are External Tables. Using Export and Import. Summary. Applying It.

18. Using Log Miner.


What Is Log Miner. Using the Log Miner Interface. Practical Uses for Log Miner. Oracle9i Enhancements. Summary. Applying It.

V. PUTTING IT ALL TOGETHER.

19. Putting It All Together: A Sales Tracking Application.


Application Concepts. The Sales Tracking Application. Book Summary.

VI. APPENDICES.

A. Answers to Quizzes.
B. Oracle9i Architecture and Complete Sales Tracking Installation Scripts.
C. Software Web Sites.
Glossary.
Index.