Oracle 9i: The Complete Reference (With CD)

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

Publisher: Tata McGraw-Hill
Edition: Paperback
Edition Number: 1
Language: English
ISBN: 0070499020
EAN: 9780070499027
No. of Pages: 1,304
Publish Date: 2002
Binding: Paperback
Sold by Asian Books ( Average Ratings: Rating of 4.8 out of 5 Rating of 4.8 out of 5 Rating of 4.8 out of 5 Rating of 4.8 out of 5 Rating of 4.8 out of 5 )
Ships in 2 - 3 Days. ( FREE Shipping in India )
Cash On Delivery is available for this product
Ships to India.
Check Delivery to my Area

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

show moreless

Specification

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

Disclaimer

  • 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.


Great Value

Safe Payment

Shop With
Confidence

24/7 Help Center

Free & Easy Return

Get Discounts & Offers
Stay Connected
Copyright © 2007-2016 Infibeam.com and Affiliates