Oracle8I from Scratch

by Hotka, Dan

• ISBN13: 9780789723697
• ISBN10: 0789723697
• Edition: 1st
• Format: Paperback
• Copyright: 2000-09-28
• Publisher: Que Publishing

Summary

Oracle8i From Scratch teaches you the key concepts and techniques associated with designing and building a relational database using Oracle8i. You will build a web-enabled "Auto Sales Tracking" application using the Oracle8i relational database, Oracle Developer v6.0, Oracle Jdevoper v3.0, and Oracle Web Server v3.0. Oracle8i Database Development From Scratch also covers the basic administrative and tuning tasks necessary to insure a smooth running application.

Author Biography

Dan Hotka has been an Oracle Developer and Administrator for over 16 years and has over 9 years experience as a Oracle instructor, is frequently published in trade journals, and regularly speaks at Oracle and Oracle User Group conferences around the world. Dan has co-authored the popular books Oracle Unleashed, Oracle8 Server Unleashed, Oracle Development Unleashed and Special Edition using Oracle8/8i.

Table of Contents

Introduction	1	(6)
Introduction to Oracle8i and the Auto Sales Tracking Application	7	(36)
Building the Sales Tracking Application Database	43	(12)
Building the Sales Tracking Application Forms and Reports	55	(54)
Basic Oracle8i Administration Tasks	109	(20)
Monitoring the Sales Tracking Application	129	(28)
Tuning the Sales Tracking Application	157	(14)
Oracle8i Backup and Recovery	171	(18)
Understanding Oracle8i Index and Partitioning Features	189	(18)
Planning the Sales Tracking Web Site	207	(14)
Building the Web Site with PL/SQL	221	(24)
Building the Web Site with Java	245	(26)
Building Web-Based Forms with WebDB	271	(10)
Appendix A Installation and Configuration of Oracle8i NT-Based Software	281	(28)
B Learning SQL---A Complete Tutorial	309	(44)
C PL/SQL Basics	353	(22)
D Advanced SQL Queries	375	(22)
Index	397