Cover image for Oracle8i from scratch
Oracle8i from scratch
Hotka, Dan.
Personal Author:
Publication Information:
Indianapolis, Ind. : Que, [2000]

Physical Description:
vii, 414 pages : illustrations ; 24 cm.
General Note:
"Userlevel: Beginning-Intermediate"--Cover.

Includes index.
Title Subject:
Subject Term:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 H675 2000 Adult Non-Fiction Central Closed Stacks

On Order



A guide to Oracle8i which explains the intricacies of building both windows and web based applications. The text introduces a variety of terms, jargon and technologies and can be used as both a learning aid and a reference guide.

Author Notes

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

Introductionp. 1
Chapter 1 Introduction to Oracle8i and the Auto Sales Tracking Applicationp. 7
Oracle--A Relational Databasep. 7
What Is a Database?p. 8
What Is SQL?p. 11
Oracle8/8i Featuresp. 13
Oracle's Implementation of SQLp. 16
Introduction to Oracle Toolsp. 17
Oracle Developer 6.0 (Forms, Reports, and Graphics)p. 18
SQL*Plusp. 22
SQL*Loaderp. 23
Net8--Oracle's Networking Protocolp. 24
The Export and Import Utilitiesp. 26
Introduction to the Auto Sales Tracking Applicationp. 29
The Sales Tracking Database Layoutp. 29
The Sales Tracking Programsp. 35
Summaryp. 41
Next Stepsp. 41
Chapter 2 Building the Sales Tracking Application Databasep. 43
Relational Schema Design and Database Constructionp. 43
An Overview of Tables and Indexesp. 44
Building the Sample Application Databasep. 45
Tablespace Layoutp. 45
Creating the Database (Tables, Indexes, and Constraints)p. 49
Creating Database Triggersp. 53
Summaryp. 54
Next Stepsp. 54
Chapter 3 Building the Sales Tracking Application Forms and Reportsp. 55
Building the Sales Tracking Formsp. 55
Oracle Developer for Formsp. 55
Oracle Developer for Reportsp. 94
Oracle SQL*Plus for Reportsp. 99
Sales Tracking Application Icon Setupp. 106
Summaryp. 108
Next Stepsp. 108
Chapter 4 Basic Oracle8i Administration Tasksp. 109
Database Startup/Shutdownp. 111
What Is the Intialization File (INIT.ORA)?p. 113
Adding Usersp. 117
Grants, Privileges, and Rolesp. 118
Grantsp. 119
Privilegesp. 119
Rolesp. 120
Owner/Location Transparency--Synonymsp. 121
Basic Tablespace Maintenancep. 122
Adding a Tablespacep. 124
Adding Space to Tablespacesp. 125
Oracle8i Tablespace Optionsp. 126
Summaryp. 128
Chapter 5 Monitoring the Sales Tracking Applicationp. 129
Oracle System Global Areap. 129
Buffer Cachep. 130
Other SGA Structures: Library Cache, Dictionary Cache, and Large Poolp. 135
Understanding the INIT.ORA Parametersp. 137
Using Tablespaces for Table and Index Placement on Disk Storagep. 141
Monitoring Oracle8i and the Sales Tracking Applicationp. 146
Understanding Database Fragmentationp. 150
What Is Database Fragmentation?p. 150
Discovering Database Fragmentationp. 153
Summaryp. 154
Next Stepsp. 155
Chapter 6 Tuning the Sales Tracking Applicationp. 157
What Is the SQL Explain Plan?p. 157
The Oracle Optimizersp. 158
Tuning the Sales Tracking Application SQL Statementsp. 164
SQL Coding Guidelinesp. 170
Summaryp. 170
Next Stepsp. 170
Chapter 7 Oracle8i Backup and Recoveryp. 171
Why Back Up My Oracle8i Database?p. 171
Basic Oracle8i Backup and Recoveryp. 172
Cold Backup and Restorep. 176
Hot Backup and Restorep. 181
Incremental Backupsp. 183
Which Backup Method Is Best?p. 186
Summaryp. 187
Next Stepsp. 188
Chapter 8 Understanding Oracle8i Index and Partitioning Featuresp. 189
Understanding Indexesp. 189
What Is a B-Tree Index?p. 191
What Is an IOT?p. 192
What Are the Oracle8i Indexing Options?p. 193
Implementing IOTs in the Sales Tracking Applicationp. 195
What Is Partitioning?p. 195
Oracle8i Partitioning Optionsp. 196
Range Partitioningp. 197
Hash Partitioningp. 199
Composite Partitioningp. 200
Oracle8i Index Partitioning Optionsp. 201
Types of Index Partitioningp. 201
Prefixed Versus Nonprefixed Partitioned Indexesp. 202
Evaluating the Index Partitioning Optionsp. 203
Summaryp. 205
Chapter 9 Planning the Sales Tracking Web Sitep. 207
Sales Tracking Application Web Site--Buying a Carp. 210
What Is OAS?p. 212
Basic OAS Featuresp. 215
Basic OAS Administrationp. 215
Converting the Sales Tracking Forms to Web Pagesp. 216
Web-Based Strategiesp. 217
PL/SQLp. 217
Javap. 218
WebDBp. 219
Summaryp. 219
Next Stepsp. 219
Chapter 10 Building the Web Site with PL/SQLp. 221
Using PL/SQLp. 221
Displaying Pictures with PL/SQL and HTMLp. 223
Passing Parameters from PL/SQL to HTMLp. 227
Building the Web Sitep. 230
Summaryp. 243
Next Stepsp. 243
Chapter 11 Building the Web Site with Javap. 245
Java VMp. 245
Java Development Toolsp. 246
Using Javap. 246
Building a Java Servlet with JDeveloper v3.0p. 246
Deploying the Java Servlet Applicationp. 250
Running the Java Servlet Applicationp. 252
OAS and Java Setupp. 253
Displaying Pictures and Passing Parameters with Javap. 257
Java Code Reusep. 259
Building the Web Sitep. 260
Summaryp. 268
Next Stepsp. 269
Chapter 12 Building Web-Based Forms with WebDBp. 271
What Is WebDB?p. 271
WebDB Administrationp. 272
Using WebDB in the Sales Tracking Applicationp. 273
Creating a WebDB Sales Tracking Applicationp. 273
Creating a WebDB Sales Tracking Web Sitep. 277
Summaryp. 280
Appendix A Installation and Configuration of Oracle8i NT-Based Softwarep. 281
Oracle8i Architecturep. 281
Hardware Requirementsp. 290
Oracle8i NT Database Software Installp. 291
Problem-Solving DBMS Installp. 295
Installing the Oracle Development Toolsp. 296
Installing the Oracle WebDBp. 299
Installing the Oracle Application Serverp. 300
Installing the Quest Software Toolsp. 302
Installing Quest SQL Navigatorp. 302
Installing Quest SQLab/Xpertp. 306
Installing Quest Instance Monitorp. 307
Summaryp. 308
Appendix B Learning SQL--A Complete Tutorialp. 309
SQL Historyp. 309
Log In to the Databasep. 309
The SQL Editorp. 311
Introduction to SQLp. 313
Tables EMP/DEPT Setupp. 314
Learning the Basicsp. 314
SQL Queriesp. 316
SQL Data Manipulationp. 320
Creating Objects with SQLp. 326
Advanced SQL Queriesp. 343
Functionsp. 343
Summaryp. 351
Appendix C PL/SQL Basicsp. 353
PL/SQL and Why to Use Itp. 353
PL/SQL Basic Syntaxp. 355
PL/SQL Variablesp. 357
PL/SQL Cursorsp. 363
PL/SQL Logic Controlp. 366
Debugging Our PL/SQLp. 370
Error Handling in PL/SQLp. 371
Summaryp. 373
Appendix D Advanced SQL Queriesp. 375
Understanding SQL Functionsp. 375
Single-Row Functionsp. 375
Multiple-Row Functions or Group Functionsp. 381
Using Multiple Functionsp. 382
Indexing on Functionsp. 383
Table Join Conditionsp. 384
SQL Subqueriesp. 388
Complex Viewsp. 392
Read Consistencyp. 393
Indexp. 397