
Oracle Database 10g The Complete Reference
The Complete Reference
Kevin Loney(Author)
Osborne/McGraw-Hill (Publisher)
Will be published approx. on 16. September 2004
Book
Paperback/Softback
1392 pages
978-0-07-225351-1 (ISBN)
Description
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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.
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.
More details
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
300 Illustrations
Dimensions
Height: 232 mm
Width: 200 mm
Thickness: 78 mm
Weight
2303 gr
ISBN-13
978-0-07-225351-1 (9780072253511)
Schweitzer Classification
Person
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 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