Professional Oracle Programming / Edition 1

Professional Oracle Programming / Edition 1

by Rick Greenwald, Robert Stackowiak, Gary Dodge, David Klein
     
 

Professional Oracle Programming

If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to

See more details below

Overview

Professional Oracle Programming

If you are a developer who wants to use Oracle to build effective, robust, and scalable software applications, look no further. Written by a team of leading authorities on the Oracle database, this example-packed book is divided into three main areas: how the Oracle database works, how to use SQL and programming languages to access Oracle, and how to use the features of Oracle effectively in creating your applications.

After an overview of the topics you need to know in order to use the Oracle database effectively, you'll get helpful tips, techniques, code samples, and examples written in Oracle Database 10g. Along the way, you'll learn how to access and manipulate data in the Oracle database, implement logic with various programming techniques, use raw data in a database, and, ultimately, create successful applications.

What you will learn from this book

  • How to leverage Oracle's strengths in both its functionality and operations
  • Various database issues that have a direct impact on the operation and performance of Oracle applications
  • Techniques for using triggers, regular expressions, object types, XML, and HTML-DB with Oracle
  • How Oracle processes SQL requests and the implication this can have on application code
  • Ways Oracle determines optimal access paths to data and how to shape the behavior of an Oracle database

Who this book is for

This book is for anyone whose primary job is to create application systems and who wants to use the Oracle database for such systems. A basic knowledge of Oracle, Java, and SQL is recommended.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Read More

Product Details

ISBN-13:
9780764574825
Publisher:
Wiley
Publication date:
05/09/2005
Series:
Wrox Professional Guides Ser.
Edition description:
New Edition
Pages:
790
Product dimensions:
7.44(w) x 9.26(h) x 1.71(d)

Table of Contents

About the Authors.

Acknowledgments.

Introduction.

Introduction.

What Does This Book Cover?

Who Is This Book For?

What You Need to Use This Book.

How Is This Book Structured?

Part I: Oracle Essentials.

Part II: Data Topics.

Part III: Database Programming Languages.

Part IV: Programming Techniques.

Part V: Business Intelligence Techniques.

Part VI: Optimization.

The Bigger Picture.

Conventions.

Source Code.

Errata.

p2p.wrox.com.

Chapter 1: Oracle Architecture and Storage.

Chapter 2: Using SQL.

Chapter 3: Handling Multiple Users.

Chapter 4: Database Design Basics.

Chapter 5: Oracle Security.

Chapter 6: The Oracle Data Dictionary.

Chapter 7: Installing Oracle.

Chapter 8: Introduction to SQL.

Chapter 9: Extended SQL.

Chapter 10: Indexes.

Chapter 11: Constraints.

Chapter 12: Other Database Structures.

Chapter 13: Functions.

Chapter 14: Distributed Queries, Transactions, and Databases.

Chapter 15: PL/SQL Basics.

Chapter 16: PL/SQL and SQL.

Chapter 17: PL/SQL Packages.

Chapter 18: Introduction to Java Database Programming.

Chapter 19: Triggers.

Chapter 20: Regular Expressions and Expression Filter.

Chapter 21: Object Relational Interactions with Oracle.

Chapter 22: Oracle XML DB.

Chapter 23: HTML-DB.

Chapter 24: High-Speed Data Movement.

Chapter 25: Data Loading and Management.

Chapter 26: Business Intelligence Query.

Chapter 27: Business Intelligence Analysis.

Chapter 28: Optimization.

Index.

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >