Professional Oracle Programming

Rick Greenwald, Robert Stackowiak, Gary Dodge, David Klein, Ben Shapiro, Christopher G. Chelliah - Collection Programmer to Programmer

758 pages, parution le 06/07/2005

Ajouter à une liste

Indisponible

Résumé

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.

L'auteur - Rick Greenwald

Rick Greenwald has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has been a principal author of ten books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. In addition to Oracle in a Nutshell, Rick's books include Oracle Essentials: Oracle9i, Oracle8i, and Oracle8 (principal author with Robert Stackowiak and Jonathan Stern, O'Reilly & Associates, 2001), Oracle Power Objects Developer's Guide (principal author with Kasu Sista and Richard Finklestein, Oracle Press, 1995); Mastering Oracle Power Objects (principal author with Robert Hoskins, O'Reilly & Associates, 1996); Using Oracle Web Server (principal author with many others, Que Publishing, 1997); The Oracle WebDB Bible (principal author with Jim Milbery, IDG Books Worldwide, 1999); and Administering Exchange Server (principal author with Walter Glenn, Microsoft Press, 1999).

L'auteur - Robert Stackowiak

Robert Stackowiak has worked for 20 years in IT industry related roles that have included software development, management of software development, systems engineering, sales and sales consulting, and business development. He currently is recognized worldwide as a field sales expert in data warehousing at Oracle, and previously was well recognized for his work at IBM's RISC System/6000 Division, Harris Computer Systems, and the U.S. Army Corps of Engineers. Bob has spoken at numerous computer related conferences and has conducted briefings with companies based around the world. His papers regarding data warehousing and computer and software technology have appeared in publications such as The Data Warehousing Institute's Journal of Data Warehousing, Informix Tech Notes, and AIXcellence Magazine.

L'auteur - Gary Dodge

Gary Dodge has served in technical and managerial roles within Oracle Corporation since 1987.

Sommaire

Introduction
Oracle Architecture and Storage
Using SQL
Handling Multiple Users
Database Design Basics
Oracle Security
The Oracle Data Dictionary
Installing Oracle
Introduction to SQL
Extended SQL
Indexes
Constraints
Other Database Structures
Functions
Distributed Queries, Transactions, and Databases
PL/SQL Basics
PL/SQL and SQL
PL/SQL Packages
Introduction to Java Database Programming
Triggers
Regular Expressions and Expression Filter
Object Relational Interactions with Oracle
Oracle XML DB
HTML-DB
High-Speed Data Movement
Data Loading and Management
Business Intelligence Query
Business Intelligence Analysis
Optimization
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wrox Press
Auteur(s)	Rick Greenwald, Robert Stackowiak, Gary Dodge, David Klein, Ben Shapiro, Christopher G. Chelliah
Collection	Programmer to Programmer
Parution	06/07/2005
Nb. de pages	758
Format	18,5 x 23,5
Couverture	Broché
Poids	1127g
Intérieur	Noir et Blanc
EAN13	9780764574825
ISBN13	978-0-7645-7482-5