iPhone 6 : Order now for Same Day Shipping Best Deals On Cameras Avail Extra 5% off on Car Audio & Visual Systems
Oracle 9i: The Complete Reference (With CD)

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

Publisher: Tata McGraw-Hill
Edition: Paperback
Edition Number: 1
ISBN: 0070499027
EAN: 9780070499027
No. of Pages: 1,304
Publish Date: 2002
Binding: Paperback



Master all the powerful features of Oracle9

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

. 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


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


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

show moreless


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


  • The book summary and image may be of a different edition or binding of the same title.
  • Book reviews are added by registered customers. They need not necessarily buy book.
  • These books are NOT available for reading online or for free download in PDF or ebook format.
  • Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.
  • www.infibeam.com/Books is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.