To access the contents, click the chapter and section titles.

Oracle8 How-To new
(Imprint: Waite Group Press)
(Publisher: Macmillan Computer Publishing)
Author:Edward Honour, Paul Dalberth, Ari Kaplan, Atul Mehta
Publication Date:1998
ISBN:1571691235


Table of Contents

INTRODUCTION
Chapter 1: Selected Database Instance Installation Topics
Chapter 2: SQL*Plus
Chapter 3: Database Users
Chapter 4: Tables
Chapter 5: Indexes
Chapter 6: Constraints
Chapter 7: Views
Chapter 8: Security
Chapter 9: Space Management
Chapter 10: PL/SQL
Chapter 11: Querying Data
Chapter 12: Built-In Packages
Chapter 13: Triggers
Chapter 14: SQL Statement Tuning
Chapter 15: Database Tuning
Chapter 16: Create an Object Relational Database
Chapter 17: Oracle Web Application Server

Introduction

Chapter 1:   Selected Database Instance Installation Topics

   1.1 Create a new Oracle instance without using the installer?
   1.2 Create Windows NT and Oracle client services for the new instance?
   1.3 Use the password file to authenticate database administrators?
   1.4 Multiplex control files?
   1.5 Create a new control file?
   1.6 Create new tablespaces?
   1.7 Examine and change the rollback segment configuration?
   1.8 Create and multiplex redo log groups?
   1.9 Enable archive log mode?
   1.10 Start the checkpoint process?
   1.11 Enable product user profiles?

Chapter 2:   sql*plus

   2.1 Change the format of date fields returned in SQL*Plus?
   2.2 Create and use SQL*Plus command files?
   2.3 Save query results and SQL statements to a file?
   2.4 View and modify SQL*Plus system variables?
   2.5 Prompt users for substitution variables?
   2.6 Pass parameters to a SQL*Plus script?
   2.7 Use SQL*Plus as a report writer?
   2.8 Use SQL*Plus to write repetitive scripts?

Chapter 3:    Database Users

   3.1 Create a user account?
   3.2 Grant and determine user disk quotas?
   3.3 Summarize basic user account information?
   3.4 Determine who is logged on?
   3.5 Kill a user’s session?
   3.6 Determine user defaults?
   3.7 Determine user system privileges?
   3.8 Determine user object privileges?
   3.9 Create, modify, and associate user profiles?

Chapter 4:    Tables

   4.1 Create a table?
   4.2 Determine all of the tables owned by a particular user?
   4.3 Put comments on a table and its columns?
   4.4 Recreate CREATE TABLE statements?
   4.5 Determine a table’s initial size parameters?
   4.6 Use the ANALYZE command to determine access statistics?
   4.7 Create a table from another table?
   4.8 Interpret the format of ROWID?
   4.9 Create an index-organized table?
   4.10 Partition a table?

Chapter 5:    Indexes

   5.1 Determine all of the indexes on a particular table?
   5.2 Determine all of the indexes owned by a particular user?
   5.3 Determine an index’s initial size parameters?
   5.4 Detect unbalanced indexes?
   5.5 Rebuild unbalanced indexes?
   5.6 Enforce uniqueness via an index?
   5.7 Partition an index?
   5.8 Create a bitmapped index?

Chapter 6:     Constraints

   6.1 Create a primary key constraint?
   6.2 Add a foreign key constraint?
   6.3 Add a column check constraint?
   6.4 Create a table constraint?
   6.5 Determine foreign key dependencies?
   6.6 Enable, disable, and enforce constraints?
   6.7 Add cascading delete functionality?
   6.8 Create a sequence to generate a unique number?
   6.9 Determine integrity violations?
   6.10 Create a deferred constraint?

Chapter 7:    Views

   7.1 Create a view?
   7.2 Determine all of the views owned by a particular user?
   7.3 Determine if a view can be updated?
   7.4 Create an updatable join view?
   7.5 Simulate a cross-tab query using a view?
   7.6 Re-create CREATE VIEW statements?
   7.7 Implement record level security using views?

Chapter 8:     Security

   8.1 Grant system and object privileges?
   8.2 Create a role?
   8.3 Grant roles to users?
   8.4 Enable and disable roles at runtime?
   8.5 Determine the privileges associated with a role?
   ;8.6 Determine a user’s access to a particular object?
   8.7 Determine which users have access to a object?
   8.8 Enable database auditing?
   8.9 View audit information?
   8.10 Delete audit information?
   8.11 Manage passwords?

Chapter 9:    Space Management

   9.1 Detect objects close to maximum extents?
   9.2 Detect row chaining and migration in tables?
   9.3 Correct row migration in tables?
   9.4 Determine and coalesce the free space in a tablespace?
   9.5 Allocate unlimited extents for a database object?
   9.6 Deallocate unused space in a segment?
   9.7 Configure database files to extend automatically?

Chapter 10:    PL/SQL

   10.1 Create anonymous PL/SQL blocks?
   10.2 Achieve conditional and looping control?
   10.3 Create a stored procedure?
   10.4 Create a stored function?
   10.5 Create a stored package?
   10.6 List information about stored objects in the database?
   10.7 Overload procedures and functions in packages?
   10.8 Create variables to represent database records and columns?
   10.9 Achieve array functionality with PL/SQL Index-By tables?
   10.10 Handle predefined exceptions and system errors?
   10.11 Handle user-defined exceptions and user-defined errors?
   10.12 Rebuild statements to create stored modules?

Chapter 11:    Querying Data

   11.1 Issue single record queries with implicit cursors?
   11.2 Issue multiple record queries with explicit cursors?
   11.3 Use cursor attributes to monitor cursor state?
   11.4 Use cursor parameters to enhance cursor reusability?
   11.5 Use cursor variables for more flexibility?
   11.6 Use wildcards in a query?
   11.7 Lock rows when I query them?
   11.8 Prevent the selection of duplicate rows?
   11.9 Traverse a tree structure?

Chapter 12:    Built-In Packages

   12.1 Execute dynamic SQL with DBMS_SQL?
   12.2 Submit scheduled jobs with DBMS_JOB?
   12.3 Communicate between sessions with DBMS_PIPE?
   12.4 Monitor the database asynchronously with DBMS_ALERT?
   12.5 Read and write operating system files with UTL_FILE?
   12.6 Use comma separated lists with DBMS_UTILITY?
   12.7 Manage large objects with DBMS_LOB?

Chapter 13:    Triggers

   13.1 Create a database trigger?
   13.2 Use column values within database triggers?
   13.3 Fire triggers selectively using trigger predicates?
   13.4 Perform cascading deletes with database triggers?
   13.5 Disable and enable triggers ?
   13.6 List information about triggers?
   13.7 Rebuild CREATE TRIGGER statements?

Chapter 14:     SQL Statement Tuning

   14.1 Identify potentially inefficient queries with the V$SQLAREA view?
   14.2 Use EXPLAIN PLAN to analyze query execution paths?
   ;14.3 Use the AUTOTRACE system variable to analyze query execution paths?
   14.4 Determine elapsed execution time in SQL*Plus?
   14.5 Analyze SQL statements with SQL*Trace and the TKPROF utility?
   14.6 Set the optimizer mode?
   14.7 Pass hints to the optimizer?
   14.8 Suppress indexes in a query?
   14.9 Structure data warehouses for star query optimization?
   14.10 Register applications to simplify performance tracking?

Chapter 15     Database Tuning

   15.1 Run the UTLBSTAT and UTLESTAT scripts ?
   15.2 Identify unbalanced I/O and I/0 contention?
   15.3 Stripe a tablespace across multiple devices?
   15.4 Determine shared pool performance?
   15.5 Determine the buffer cache hit ratio?
   15.6 Assess the impact of adding database buffers?
   15.7 Record and save performance statistics over time?
   15.8 Identify rollback segment contention?
   15.9 Determine the best size for the redo log buffer?
   15.10 Measure and improve checkpoint performance?
   15.11 Determine and improve overall sort performance?
   15.12 Detect contention for the database buffer cache?
   15.13 Detect and resolve lock contention?

Chapter 16:     Create an Object Relational Database

   16.1 Create object types and use them in relational tables?
   16.2 Use constructor methods to populate object relational tables?
   16.3 Create and use object tables?
   16.4 Create and use the VARRAY collection type?
   16.5 Create and use the nested table collection type?
   16.6 Create and use object views?
   16.7 Issue DML commands on object views and use INSTEAD OF triggers?
   16.8 Use MAP and ORDER methods to compare objects?

Chapter 17:     Oracle Web Application Server

   17.1 Administer Database Access Descriptors (DADs) and Cartridges?
   17.2 Return the results of a query to a web document?
   17.3 Create an HTML form?
   17.4 Use multi-valued form fields?
   17.5 Use HTML tables in my web documents?
   17.6 Use JavaScript to handle events?
   17.7 Access and use CGI environment variables?
   17.8 Maintain persistent states with cookies?