Kevin Loney and George Koch, «Oracle9i : The Complete Reference»
ISBN 0072225211 | Oracle Press | August 2002 |1256 pages | pdf | 23 MB
The most reknowned Oracle Resourse- Fully Updated for Oracle 9i. Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Get comprehensive information on all the features of Oracle 9i. 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.
Table of Contents
PART I: Critical Database Concepts
1: Sharing Knowledge and Success
2: The Dangers in a Relational Database
3: The Basic Parts of Speech in SQL
4: The Basics of Object-Relational Databases
5: Introduction to Web-Enabled Databases
PART II: SQL and SQL*PLUS
6: Basic SQL*PLUS Reports and Commands
7: Getting Text Information and Changing It
8: Playing the Numbers
9: Dates: Then, Now, and the Difference
10: Conversion and Transformation Functions
11: Grouping Things Together
12: When One Query Depends upon Another
13: Some Complex Possibilities
14: Building a Report in SQL*PLUS
15: Changing Data: insert, update, merge, and delete
16: Advanced Use of Functions and Variables
17: DECODE and CASE: if, then, and else in SQL
18: Creating, Dropping, and Altering Tables and Views
19: By What Authority?
20: Changing the Oracle Surroundings
21: Using SQL*Loader to Load Data
22: Accessing Remote Data
23: Using Materialized Views
24: Using Oracle Text for Text Searches
25: Using External Tables
26: Using Flashback Queries
PART III: PL/SQL
27: An Introduction to PL/SQL
28: Triggers
29: Procedures, Functions, and Packages
PART IV: Object-Relational Databases
30: Implementing Types, Object Views, and Methods
31: Collectors (Nested Tables and Varying Arrays)
32: Using Large Objects
33: Advanced Object-Oriented Concepts
PART V: Java in Oracle
34: An Introduction to Java
35: JDBC and SQLJ Programming
36: Java Stored Procedures
PART VI: Hitchhiker’s Guides
37: The Hitchhiker’s Guide to the Oracle9i Data Dictionary
38: The Hitchhiker’s Guide to the Oracle Optimizer
39: The Hitchhiker’s Guide to Oracle9iAS
40: The Hitchhiker’s Guide to Database Administration
41: The Hitchhiker’s Guide to XML in Oracle
PART VII: Alphabetical Reference
snipped RS url below