Need to Return Your Textbook Rental?
Expert Oracle, Signature Edition Programming Techniques a... and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player

FREE Shipping on orders over $35.

Used - Acceptable | See details
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell yours here
Start reading Expert Oracle, Signature Edition Programming Techniques a... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Expert One on One Oracle [Paperback]

Thomas Kyte
4.8 out of 5 stars  See all reviews (78 customer reviews)

Available from these sellers.

Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $57.59  
Hardcover $62.05  
Paperback --  
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now
There is a newer edition of this item:
Expert One-on-One Oracle Expert One-on-One Oracle 4.8 out of 5 stars (78)
Out of Print--Limited Availability

Book Description

June 2001 1861004826 978-1861004826 1
Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter course, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Tom has selected the most important features and techniques and he teaches them in a proof-by-example manner, not only discussing the features available, but also how to implement software using them and indicating the potential pitfalls.

This book covers:
Core database structures and utilities
Performance tuning
Advanced SQL features
Extensibility using C, Java and OR features
Important supplied packages

Editorial Reviews Review

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: scope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book.

Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is eminently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle databases. --David Wall

Topics covered: Deep wisdom on developing applications for Oracle database management systems, as well as plenty of advice on designing and administering them. There are sections on general design and implementation practices, application architecture, locking and concurrency, transactions and rollbacks, importing and exporting, and lots more of interest to developers.

From the Publisher

This book offers the knowledge required for both those who build Oracle database applications, and those who administer the database.

It is critical that the DBA knows what the developers are trying to accomplish and the best developers know how to exploit the DBA's data management strategies. Armed with the fundamental knowledge of the Oracle environment that Tom describes, you will be able to build bigger, faster, and more scalable applications.

Knowledge of SQL and PL/SQL is assumed and familiarity with any 3GL language (such as C, Java, or Visual Basic) would be useful.

Product Details

  • Series: Programmer to Programmer
  • Paperback: 1265 pages
  • Publisher: Peer Information Inc.; 1 edition (June 2001)
  • Language: English
  • ISBN-10: 1861004826
  • ISBN-13: 978-1861004826
  • Product Dimensions: 9.3 x 7.4 x 2.4 inches
  • Shipping Weight: 4.4 pounds
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (78 customer reviews)
  • Amazon Best Sellers Rank: #1,256,008 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews
23 of 24 people found the following review helpful
5.0 out of 5 stars Sage Advice From The Oracle Expert April 22, 2003
Format:Paperback|Verified Purchase
This book belongs on every developer, team leader, or DBAs desk that works with Oracle. Kyte has written a masterpiece in advanced Oracle knowledge. He does three things very well in this book: tells you what is important in Oracle, why it is important, and what happens if you do things the wrong way.
Kyte starts out giving the foundations for Oracle databases, the architecture, locking schemes, and table and index considerations. He gives a good treatment of the types of tables and indexes that Oracle offers including the appropriate times to use them and the trade-offs to weigh.
Another key topic that he covers is redo and rollback. These features are handled in a unique way in Oracle, and a lack of understanding can lead to inefficient and incorrect databases and applications.
Armed with the foundations, Kyte then takes the reader through performance tuning and optimizing databases. The best advice in this section is that performance cannot be thrown in at the end. The design decisions for a database will determine how it performs and scales. As he says, "There is no fast=true setting in the init parameters."
Then the book tackles some more advanced features, such as autonomous transactions, dynamic sql, and C and Java extensions for stored procedures. Kyte again gives good advice for when these are appropriate over standard PL/SQL stored procedures.
The size of the book can be intimidating at first glance, but it is pleasant to read. Kyte uses a conversational style rather than a lecturing delivery. This book has a lot to offer, and you won't find yourself tired after reading it.
Comment | 
Was this review helpful to you?
17 of 17 people found the following review helpful
5.0 out of 5 stars Best Oracle Book Ever! November 14, 2001
I've been developing Oracle applications for many years and have never found a book more resourceful than Tom's. It is packed full of valuable information and is a must have for anyone working with Oracle. It covers many aspects application development from a variety of languages including C, PL/SQL and Java. Most Oracle books are strictly for reference, this book makes for good reference but also is great reading and covers interesting concepts. Chapter 1 in this book is called "Developing Successful Oracle Applications" and is a must read. I recently found that my long running query was not properly using the index I created. I looked in Tom's book and found the answer to my problem under a section called "Why isn't my Index Getting Used?" What more could you ask for? If you're a beginner, intermediate or advanced programmer, or DBA this book is for you.
Comment | 
Was this review helpful to you?
16 of 16 people found the following review helpful
4.0 out of 5 stars A treasure-trove of insights! May 11, 2004
Format:Paperback|Verified Purchase
This book attempts to cover dozens of subjects, and as such is 1,300 pages in length! Each subject contains gems of insight that had escaped me for some years now. I very much recommend this book if you are going to do any PL/Sql or Java coding. Read a chapter a day and really think about what Tom is saying. If you are really going to write industrial-strength code then you need this book, as Oracle Documentation and Oracle-Press books (I own several) tend to be quite shallow and omit explanations that Tom includes.
If there is a downside, it is that only a few pages are dedicated to any one subject, meaning that while there are many gems, this is not a book to learn the basics from and it does not cover any one subject completely. But then again, I have not seen an Oracle book that does. I wish Tom would write an entire series of books of this quality; I would buy it in a heart-beat!
P.S. Make sure that you get the 2003 version of this book from "APress", as I purchased one from the "New and Used" and got stuck with the 2001 version from "Oracle Press". Apparently Amazon does not require such disclosure.
Comment | 
Was this review helpful to you?
26 of 29 people found the following review helpful
5.0 out of 5 stars For Programmers, This is the Best Oracle Book Ever. July 10, 2001
If you are an Oracle programmer, or a DBA that works with programmers (and has to tell them all the things that they are supposed to know), this the best book you can buy. There are books by people that can program, and books by writers who can write but don't quite understand what they are writing about and there are a million other faults a book could have, but this book has none of them. Tom Kyte is at the very top of Oracle programming and he is a teacher who wants you to be able the do the same thing. Every topic in this book "reaches the ground". Tom starts from setting up your environment, and takes you through many high level exercises, showing you how to make it work, every single step of the way. He is teacher like W. Richard Stevens and Steve Rago.
There is too much to describe it all but as an example, there is a 70 page section on writing a C-Based external procedure. It starts with six pages of setting up your environment (listener, schema, server, exproc program, libraries), then the code in PL/SQL and C, how to make it, how to install it, how to test it, and ends with the answer to every error message you might get if you make a mistake.
The applications discussed are not just "interesting" and they don't just "work". There is a recurring theme in all of the applications and that is this: they scale. Tom has sections on bind variable, and then more on bind variables, and then more on bind variables, until the idea is branded on you that a "working" application is trivial unless it scales. You aren't writing code for developers, but for end users who may do millions of transactions a day; that is the kind of code you want.
If you already know everything, you will learn more, but either way Tom's projects are complete, and well documented; you can learn this.
This is great book, you will read all 1200 pages.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
1.0 out of 5 stars received 2001 edition, not as advertised
I order Tom's Expert one-on-one Oracle 2nd for $50.00. The image that I clicked on was for the 2nd edition, 2003. When I received the book, it was the 2001 edition, not the 2003. Read more
Published 4 months ago by james r mayers
5.0 out of 5 stars Great Pricing Great Service
Got the book on time and in a better condition than explained.

Thank You
Published on October 3, 2009 by Kanthi Reddy Saddi
5.0 out of 5 stars Best $12 I ever spent!!!
I bought this book on cheap clearance after the original publisher went out of business -- the best $12 I ever invested. Read more
Published on June 16, 2006 by Duke P. Ganote
4.0 out of 5 stars Fantasic
A true masterpiece, and a great way to learn Oracle concepts. No more to say.
Published on March 14, 2006 by Kelly
5.0 out of 5 stars Detailed and well explained
Thick Oracle book which is intended for developers who might need to understand the Oracle internals and administration parts besides writing SQL. Read more
Published on February 28, 2006 by Wallace Chan
5.0 out of 5 stars Good stuff for all
Gr8 stuff for all the Oracle ppl.
Published on January 12, 2006 by ushastry
5.0 out of 5 stars The gold standard for Oracle DBAs and developers
I have been an Oracle DBA for about six years and this book is still the one I turn to when looking for deeper insight into tough Oracle problems. Read more
Published on December 29, 2005 by Benjamin S. Prusinski
5.0 out of 5 stars An insider's in-depth guide to programming solutions for Oracle...
The signature edition of Thomas Kyte's Expert Oracle provides well over a thousand pages and comes from one of the leading professionals in the industry. Read more
Published on December 6, 2005 by Midwest Book Review
3.0 out of 5 stars Only covers thru version 8.1.7
I was not thorough enough in checking this book out before I ordered it (which is my fault). While Mr. Read more
Published on September 23, 2005 by Hamster
4.0 out of 5 stars where is 10g?
[A review of the 2nd EDITION 2005.]

If you follow the database field, you will know of IBM having published a series of books explaining the details of DB2. Read more
Published on May 22, 2005 by W Boudville
Search Customer Reviews
Search these reviews only


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category