Oracle 9i: The Complete Reference (With CD)
Oracle 9i: The Complete Reference (With CD) Book 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
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
The book Oracle 9i: The Complete Reference (With CD) by
(author) is published or distributed by Tata McGraw-Hill [0070499027, 9780070499027].
This particular edition was published on or around 2002 date.
Oracle 9i: The Complete Reference (With CD) has Paperback binding and this format has 1,304 number of pages of content for use.
The printed edition number of this book is 1.
* 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.