Expert author Loney has been named Consultant of the Year by the editors of "Oracle Magazine." In this new reference, he helps readers thoroughly understand the newest and most important features of 10g. The CD-ROM is filled with PDFs of the most popular Oracle documentation, all the code examples, and a full electronic copy of the book.Expert author Loney has been named Consultant of the Year by the editors of "Oracle Magazine." In this new reference, he helps readers thoroughly understand the newest and most important features of 10g. The CD-ROM is filled with PDFs of the most popular Oracle documentation, all the code examples, and a full electronic copy of the book.Read Less
New. Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more. Table of contents PART I: Critical Database Concepts Chapter 1: Oracle Database 10g Architecture Options Chapter 2: Installing Oracle Database 10g and Creating a Database Chapter 3: Upgrading to Oracle Database 10g Chapter 4: Planning Oracle Applications? Approaches, Risks, and Standards PART II: SQL and SQL*Plus Chapter 5: The Basic Parts of Speech in SQL Chapter 6: Basic SQL*Plus Reports and Commands Chapter 7: Getting Text Information and Changing It Chapter 8: Searching for Regular Expressions Chapter 9: Playing the Numbers Chapter 10: Dates: Then, Now, and the Difference Chapter 11: Conversion and Transformation Functions Chapter 12: Grouping Things Together Chapter 13: When One Query Depends upon Another Chapter 14: Some Complex Possibilities Chapter 15: Changing Data insert, update, merge, and delete Chapter 16: DECODE and CASE: if, then, and else in SQL Chapter 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences Chapter 18: Basic Oracle Security PART III: Beyond the Basics Chapter 19: Advanced Security? Virtual Private Databases Chapter 20: Working with Tablespaces Chapter 21: Using SQL*Loader to Load Data Chapter 22: Using Data Pump Export and Import Chapter 23: Accessing Remote Data Chapter 24: Using Materialized Views Chapter 25: Using Oracle Text for Text Searches Chapter 26: Using External Tables Chapter 27: Using Flashback Queries Chapter 28: Flashback? Tables and Databases PART IV: PL/SQL Chapter 29: An Introduction to PL/SQL Chapter 30: Triggers Chapter 31: Procedures, Functions, and Packages Chapter 32: Using Native Dynamic SQL and DBMS_SQL PART V: Object-Relational Databases Chapter 33: Implementing Types, Object Views, and Methods Chapter 34: Collectors (Nested Tables and Varying Arrays) Chapter 35: Using Large Objects Chapter 36: Advanced Object-Oriented Concepts PART VI: Java in Oracle Chapter 37: An Introduction to Java Chapter 38: JDBC Programming Chapter 39: Java Stored Procedures PART VII: Clustered Oracle? The Grid Chapter 40: Oracle Real Application Clusters Chapter 41: Grid Architecture and Management PART VIII: Hitchhiker? s Guides Chapter 42: The Hitchhiker? s Guide to the Oracle Data Dictionary Chapter 43: The Hitchhiker? s Guide to Tuning Applications and SQL Chapter 44: Case Studies in Tuning Chapter 45: The Hitchhiker? s Guide to Oracle Application Server 10g Chapter 46: The Hitchhiker? s Guide to Database Administration Chapter 47: The Hitchhiker? s Guide to XML in Oracle Appendix: Alphabetical Reference Printed Pages: 1400..
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited, Baker & Taylor, Inc., or by their respective licensors, or by the publishers, or by their respective licensors. For personal use only. All rights reserved. All rights in images of books or other publications are reserved by the original copyright holders.