Signed Edition Sweepstakes
 
 

Recently Viewed clear list


Original Essays | September 15, 2014

Lois Leveen: IMG Forsooth Me Not: Shakespeare, Juliet, Her Nurse, and a Novel



There's this writer, William Shakespeare. Perhaps you've heard of him. He wrote this play, Romeo and Juliet. Maybe you've heard of it as well. It's... Continue »

spacer

Oracle Database 10G : the Complete Reference - With CD (04 Edition)

by

Oracle Database 10G : the Complete Reference - With CD (04 Edition) Cover

ISBN13: 9780072253511
ISBN10: 0072253517
Condition: Student Owned
All Product Details

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

The Ultimate Resource on Oracle Database 10g

Get thorough coverage of Oracle Database 10g from the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. Youll also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics.

  • Install Oracle Database 10g or upgrade from an earlier version
  • Execute SQL queries
  • Perform complex searches easily with regular expression functions
  • Implement security measures using Virtual Private Databases (VPDs)
  • Move data with SQL*Loader and Data Pump
  • Replicate data and aggregations using materialized views
  • Execute flashback queries to recover data or see its changes over time
  • Create triggers, stored procedures, and packages with PL/SQL
  • Develop applications with JDBC and XML
  • Work with Oracle Database 10g Real Application Clusters (RAC) and grid technologies
  • Take advantage of the new tuning features

CD-ROM includes a searchable electronic book and all code examples from the book.

About the Author - Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazines Editors Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.

Synopsis:

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.

Synopsis:

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 ApplicationsApproaches, 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 SecurityVirtual 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: FlashbackTables 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 OracleThe Grid

Chapter 40: Oracle Real Application Clusters

Chapter 41: Grid Architecture and Management

PART VIII: Hitchhikers Guides

Chapter 42: The Hitchhikers Guide to the Oracle Data Dictionary

Chapter 43: The Hitchhikers Guide to Tuning Applications and SQL

Chapter 44: Case Studies in Tuning

Chapter 45: The Hitchhikers Guide to Oracle Application Server 10g

Chapter 46: The Hitchhikers Guide to Database Administration

Chapter 47: The Hitchhikers Guide to XML in Oracle

Appendix: Alphabetical Reference

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

gogo25, December 29, 2006 (view all comments by gogo25)
This is the best book I've ever found. I've 3 different books of 8i version also and depending on my experience with these 3 books and hoping to get this latest 10G book, will enable me to develop fast, robust, centralized application for consulting firms.
Was this comment helpful? | Yes | No
(2 of 2 readers found this comment helpful)

Product Details

ISBN:
9780072253511
Editor:
McClain, Lisa
Publisher:
McGraw-Hill/Osborne Media
Author:
Loney, Kevin
Subject:
Database Management - General
Subject:
Database Management - Oracle
Subject:
Relational databases
Subject:
Database design
Copyright:
Edition Number:
1
Series:
Complete Reference
Publication Date:
September 2004
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
1369
Dimensions:
9.32x7.36x2.88 in. 5.18 lbs.

Other books you might like

  1. Oracle Database 10g RMAN Backup &... New Trade Paper $65.00
  2. Oracle Database 10g Linux... New Trade Paper $67.69
  3. Oracle Database 10g: A Beginner's Guide Used Trade Paper $22.00
  4. Oracle Essentials 3RD Edition Oracle 10G Used Trade Paper $3.75
  5. A Sacred Sorrow: Meeting God in the... Used Trade Paper $7.95

Related Subjects

» Computers and Internet » Database » Applications
» Computers and Internet » Database » Design
» Computers and Internet » Software Engineering » Software Management

Oracle Database 10G : the Complete Reference - With CD (04 Edition) Used Trade Paper
0 stars - 0 reviews
$36.00 In Stock
Product details 1369 pages McGraw-Hill/Osborne Media - English 9780072253511 Reviews:
"Synopsis" by , 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.

"Synopsis" by , 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.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.