Oracle 9i: The Complete Reference (With CD) (Paperback)

Oracle 9i: The Complete Reference (With CD) Book Description

Description:

Master all the powerful features of Oracle9
i

using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9
i

. This is a must-have reference 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

Book Details

Title:	Oracle 9i: The Complete Reference (With CD)
Publisher:	Tata McGraw-Hill
Edition:	Paperback 1st Edition
Edition Number:	1
ISBN:	0070499027
EAN:	9780070499027
No. of Pages:	1,304

Deliverable Countries: This product ships to India, Sri Lanka.

Customer Reviews : Oracle 9i: The Complete Reference (With CD)

Discussion : Oracle 9i: The Complete Reference (With CD)

No Discussion has been started.  See Latest Discussions