Professional Oracle Programming (Programmer to Programmer) [Paperback]

Rick Greenwald (Author), Robert Stackowiak (Author), Gary Dodge (Author), David Klein (Author), Ben Shapiro (Author), Christopher G. Chelliah (Author)

Book Description

ISBN-10: 0764574825 | ISBN-13: 978-0764574825 | Publication Date: June 17, 2005 | Edition: 1

• One of the only Oracle books to focus exclusively on database programming rather than administration
• Oracle owns sixty percent of the commercial database market
• Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i
• The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials
• Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL

Editorial Reviews

Review

“…a good book for an introduction to Oracle, but especially good if you are interested in the areas of Business Intelligence, HTML-DB, XML DB and Regular Expressions…” (OracleHome, 3 August 2005)

From the Back Cover

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.

See all Editorial Reviews

Product Details

• Paperback: 790 pages
• Publisher: Wrox; 1 edition (June 17, 2005)
• Language: English
• ISBN-10: 0764574825
• ISBN-13: 978-0764574825
• Product Dimensions: 9.2 x 7.4 x 1.7 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,038,164 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

18 of 19 people found the following review helpful:

5.0 out of 5 stars For the Professional Developer, June 15, 2005

By 

John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   

This review is from: Professional Oracle Programming (Programmer to Programmer) (Paperback)

This is an intermediate level book. It is intended for the application developer who already has some knowledge of SQL (which implies some knowledge of what databases do) and of programming (particularly Java). For instance, the first chapter of this book is on the internal structure of Oracle. That's a long ways from the standard beginning of this is what a database does.

A thing this book is not for is the database administrator. There's very little on things like set-up, assigning users, security (there's a little on this); those kinds of administrative details. This book is, as I said at first, for developers.

The book does go heavily into programming techniques like triggers, regular expressions, object types, XML, defining your own functions -- things like that.

The authors all have extensive experience with Oracle, most of them work for or have worked for Oracle. As this series of books proclaims, this is a book written at the programmer to programmer level.

8 of 9 people found the following review helpful:

5.0 out of 5 stars Excellent book for the serious developer!, June 21, 2005

By 

bjork fan (nj, usa) - See all my reviews

This review is from: Professional Oracle Programming (Programmer to Programmer) (Paperback)

I have read all the books on Oracle and most seem pretty fluffy - lots of pages but the content is on a pretty basic level. This is the first book I have seen that really delves into the guts of Oracle - how it works, and how to program applications effectively for it. Just what I have been looking for!!!

5.0 out of 5 stars Excellent book., August 14, 2009

By 

C. Smith - See all my reviews
(REAL NAME)   

This review is from: Professional Oracle Programming (Programmer to Programmer) (Paperback)

This is an excellent book on Oracle which targets developers. It is very thorough yet easy to follow. This is the best book about Oracle I've read yet.