Complete Guideline and Reference for

Engineering Students related to Study and Reference Material of GATE.

-- Just Click it and Save it for Yours --

Search Books

Free Download - ORACLE 9i - THE COMPLETE REFERENCE : By Kevin Loney & George Koch.


Author : KEVIN LONEY ,
           GEORGE KOCH and 
           Experts at TUSC.
Edition : FIRST EDITION
Publisher : McGrew - Hill Osborne Media

ISBN - 10 Number : 0-07-222521-1
ISBN - 13 Number : 978-0072225211

BOOK Length : 1214 pages
BOOK File Format : PDF
BOOK Language : English

BOOK Description :

Master all the powerful features of Oracle9i 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 Oracle9i. This is a must-have reference for all Oracle professionals.

Table of Content :
  • PART - I : Critical Database Concepts
Chapter - 1 : Sharing Knowledge and Success
Chapter - 2 : The Dangers in a Relational Database
Chapter - 3 : The Basic Parts of Speech in SQL
Chapter - 4 : The Basics of Object-Relational Databases
Chapter - 5 : Introduction to Web-Enabled Databases
  • PART - II : SQL and SQL*PLUS
Chapter - 6 : Basic SQL*PLUS Reports and Commands
Chapter - 7 : Getting Text Information and Changing It
Chapter - 8 : Playing the Numbers
Chapter - 9 : Dates: Then, Now, and the Difference
Chapter - 10 : Conversion and Transformation Functions
Chapter - 11 : Grouping Things Together
Chapter - 12 : When One Query Depends upon Another
Chapter - 13 : Some Complex Possibilities
Chapter - 14 : Building a Report in SQL*PLUS
Chapter - 15 : Changing Data: insert, update, merge, and delete
Chapter - 16 : Advanced Use of Functions and Variables
Chapter - 17 : DECODE and CASE: if, then, and else in SQL
Chapter - 18 : Creating, Dropping, and Altering Tables and Views
Chapter - 19 : By What Authority?
Chapter - 20 : Changing the Oracle Surroundings
Chapter - 21 : Using SQL*Loader to Load Data
Chapter - 22 : Accessing Remote Data
Chapter - 23 : Using Materialized Views
Chapter - 24 : Using Oracle Text for Text Searches
Chapter - 25 : Using External Tables
Chapter - 26 : Using Flashback Queries
  • PART - III : PL/SQL
Chapter - 27 : An Introduction to PL/SQL
Chapter - 28 : Triggers
Chapter - 29 : Procedures, Functions, and Packages
  • PART - IV : Object-Relational Databases
Chapter - 30 : Implementing Types, Object Views, and Methods
Chapter - 31 : Collectors (Nested Tables and Varying Arrays)
Chapter - 32 : Using Large Objects
Chapter - 33 : Advanced Object-Oriented Concepts
  • PART - V : Java in Oracle
Chapter - 34 : An Introduction to Java
Chapter - 35 : JDBC and SQLJ Programming
Chapter - 36 : Java Stored Procedures
  • PART - VI : Hitchhiker?s Guides
Chapter - 37 : The Hitchhiker?s Guide to the Oracle9i Data Dictionary
Chapter - 38 : The Hitchhiker?s Guide to the Oracle Optimizer
Chapter - 39 : The Hitchhiker?s Guide to Oracle9iAS
Chapter - 40 : The Hitchhiker?s Guide to Database Administration
Chapter - 41 : The Hitchhiker?s Guide to XML in Oracle
  • PART - VII : Alphabetical Reference



  • Click below to free download Book :
          DOWNLOAD       or       DOWNLOAD


    HOW  TO   DOWNLOAD ?
    1. Click on the download link.
    2. Wait for 5 seconds and then click on as shown in below 1st type of visual button.



    No comments:

    Post a Comment