Taylor's Library

Normal view MARC view ISBD view

Oracle9i : the complete reference / Kevin Loney, George Koch, and the experts at TUSC.

By: Loney, Kevin.
Contributor(s): Koch, George | TUSC (Firm).
Publisher: New York : McGraw-Hill/Osborne, c2002Description: xxxiii, 1256 p. : ill. ; 24 cm. + 1 CD-ROM (4 3/4 in.).ISBN: 0072225211 (set); 0072227079 (Book); 0072227087 (CD).Other title: Oracle 9i : the complete reference.Subject(s): Oracle (Computer file) | Relational databasesDDC classification: 005.7585
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 Reference
Item type Current location Call number Copy number Status Notes Date due Barcode Remark
Accompanying Material (Media Resource) TU External Storage-LCS
005.7585 ORA (Browse shelf) 1 Available SOCIT,15011,03,GR 1001001040 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

Includes index.

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 Reference