Oracle9i The Complete Reference
Published on 16. September 2002
Book
Paperback/Softback
1256 pages
978-0-07-222521-1 (ISBN)
Description
Oracle9i The Complete Reference provides comprehensive coverage of new topics core to the 9i release including new functions and commands, the Virtual Private Database (VPD), and Flashback Queries. There will also be new chapters about using other products and technologies such as Oracle9i Application Server (9iAS) and XML.
More details
Series
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
600 Illustrations
Dimensions
Height: 231 mm
Width: 188 mm
Thickness: 64 mm
Weight
1297 gr
ISBN-13
978-0-07-222521-1 (9780072225211)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine
Content
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