CodeNotes for Oracle 9i [Paperback]

Gregory Brill (Editor)

Book Description

Series: CodeNotes | Publication Date: August 13, 2002

CodeNotes provides the most succinct, accurate, and speedy way for
a developer to ramp up on a new technology or language.
Unlike other programming books, CodeNotes drills down to
the core aspects of a technology, focusing on the key elements needed in order to implement it immediately. It is a unique resource for
developers, filling the gap between comprehensive manuals and
pocket references.

Through real-world examples of PL/SQL queries, stored procedures, triggers, indexing, and more, CodeNotes for Oracle 9i illustrates the complete Oracle database framework, PL/SQL, security, administration, and optimization. Oracle’s integration with Java and support for XML are extensively covered.
This edition of CodeNotes includes:

• A global overview of this technology and explanation of what
problems it can be used to solve
• Real-world examples
• “How and Why” and “Bugs and Caveats” sections that provide hints,
tricks, workarounds, and tips on what should be taken advantage
of or avoided
• “Design Notes” illustrating many of the common use patterns
for Java programs
• Instructions and classroom-style tutorials throughout from expert
trainers and software developers


Visit www.codenotes.com for updates, source code templates, access to
message boards, and discussion of specific problems with
CodeNotes authors and other developers.

Join our nonfiction newsletter by sending a blank e-mail to:
[e-mail] or visit www.atrandom.com


Every CodeNotes title is written and reviewed by a team of commercial software developers and technology experts. See “About the Authors” at the front of the book for more information.

Editorial Reviews

From the Inside Flap

CodeNotes provides the most succinct, accurate, and speedy way for
a developer to ramp up on a new technology or language.
Unlike other programming books, CodeNotes drills down to
the core aspects of a technology, focusing on the key elements needed in order to implement it immediately. It is a unique resource for
developers, filling the gap between comprehensive manuals and
pocket references.

Through real-world examples of PL/SQL queries, stored procedures, triggers, indexing, and more, CodeNotes for Oracle 9i illustrates the complete Oracle database framework, PL/SQL, security, administration, and optimization. Oracle?s integration with Java and support for XML are extensively covered.See ?About the Authors? at the front of the book for more information.

About the Author

Gregory Brill is the series editor of CodeNotes and the founder and president of Infusion Development Corporation, a technology training and consulting firm that specializes in architecting securities trading and analytic systems for several of the world’s largest investment banks. He has written for C++ Users Journal, and is the author of Applying COM+. He lives in New York.

See all Editorial Reviews

Product Details

• Paperback: 256 pages
• Publisher: Random House Trade Paperbacks; 1st edition (August 13, 2002)
• Language: English
• ISBN-10: 0812992016
• ISBN-13: 978-0812992014
• Product Dimensions: 8.4 x 5.4 x 0.7 inches
• Shipping Weight: 9.9 ounces
• Average Customer Review: 4.0 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #3,285,077 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Amazingly effective for quickly learning Oracle 9i, August 24, 2002

By 

Mike Tarrani "www.tarrani.com" (Deltona, FL USA) - See all my reviews
(COMMUNITY FORUM 04)    (REAL NAME)   

This review is from: CodeNotes for Oracle 9i (Paperback)

If you already know Oracle 7x or 8x, you won't benefit as much from this book as you will from Oracle 9i New Features by Robert G. Freeman (ISBN 0072223855). However, if you're coming from a SQL Server, Sybase or other RDBMS environment, or are a developer who needs to quickly learn Oracle this is an ideal book.

You'll need a basic understanding of both relational databases and programming to effectively use this book. Although both topics are briefly covered, the book's pace is quick and it goes surprisingly deep into knowledge and skill factors needed to work with Oracle 9i.

Although this book is written for working professionals, it employs excellent learning techniques, such as exercises and self-tests. It's tempting to bypass them and just plough through the information, but I recommend that you work through them because you'll come away with a much deeper understanding of Oracle 9i - and will do so in less than a weekend.

The range of topics covered is what makes this book special - in less than 200 pages the book provides practical and relatively detailed information on SQL*Plus and PL/SQL, how Oracle 9i works, and even goes into tuning.

This is the first book I've read in the CodeNote series, and if the rest of the books are as well written and presented as this one I'll turn to them first when I need to become quickly functional in a particular technology.

3 of 3 people found the following review helpful:

3.0 out of 5 stars Good intro, but not enough to teach you Oracle, June 8, 2003

By A Customer

This review is from: CodeNotes for Oracle 9i (Paperback)

I bought this book to get some info on Oracle 9i to see how it was structured. It was good for explaining the terminology and showed some screenshots. But this book will not get you started using Oracle9i, it only
helps you to understand some of the syntax.

If you have a strong knowledge of SQL, then find another book, this book covers alot of java and xml explaination when dealing with 9i.

In short, if you are curious about using Oracle 9i, this book delivers
but if you want to learn the software, get another book.

1 of 1 people found the following review helpful:

3.0 out of 5 stars Noted for Brevity, September 28, 2002

By A Customer

Amazon Verified Purchase

This review is from: CodeNotes for Oracle 9i (Paperback)

The book is well written and easy to read, but it fell way short of my expectations because of its brevity. You really have to consider who this book is intended for before purchasing it. I expected it to be a summary of the most important operating aspects and gotchas with Oracle. Instead, the beef inside the bun amounted to about 100 pages that started off with a description of SELECT statements. This was way too basic for what I needed. For someone who just wants an overview of Oracle, then thisbook would probably suffice. But if you want an overview because you want to learn how to use Oracle, then chances are you're going to want much more than what this book offers. I purchased this book because it was not the behemeth volume so many authors like to produce. I give this author credit for creating something digestible. For me, however, this was just an appetizer that I had to send back to the kitchen for something heartier.