Oracle9i: The Complete Reference

Description: Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals.

* Use flashback queries to see data as it existed prior to commits
* Create, query, and manage external tables
* Create partitions, indexes, and tablespaces
* Execute and tune SQL queries
* Produce sophisticated reports using SQL*PLUS
* Load data from external files into Oracle database tables with SQL*Loader
* Create triggers, stored procedures, functions, and packages with PL/SQL
* Implement types, object views, and methods
* Develop robust database applications with SQLJ, JDBC, and XML
* Take advantage of the Oracle9i data dictionary and optimizer
* Tour the components of Oracle9i Application Server (Oracle9iAS)
* Manage, tune, back up, and recover Oracle9i databases


Link