|
Oracle 9i Development by Example (By Example)
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.
Contents:
(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.
Brief Description:
Helps you to learn the Oracle9i development environment from product installation to advanced management configuration. This book covers topics like building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding tools such as Log Miner.
|
