• Sign In
  • My Cart 0)
main product photo

Oracle Database 10g The Complete Reference

1st Edition
0071770496 · 9780071770491
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 nea… Read More
Add to Wish List
US$67.50
Request Review Copy
Download file to PC or Mac desktops or laptops

Step 1. Download Adobe Digital Editions Both PC and Mac users will need to download Adobe Digital Editions to access their eBook. You can download Adobe Digital Editions at Adobe's website here.


Step 2. Register an Adobe ID if you do not already have one. (This step is optional, but allows you to open the file on multiple devices) Visit account.Adobe.com to register your Adobe account.


Step 3: Authorize Adobe Digital Editions using your Adobe ID. In Adobe Digital Editions, go to the Help menu. Choose “Authorize Computer.”


Step 4: Open your file with Adobe Digital Editions. Once you’ve linked your Adobe Digital Editions with your Adobe ID, you should be able to access your eBook on any device which supports Adobe Digital Editions and is authorized with your ID. If your eBook does not open in Adobe Digital Editions upon download, please contact customer service

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

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.