Gift Guide

Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7 / Edition 1

Hardcover (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Hardcover)
  • All (12) from $1.99   
  • New (4) from $21.56   
  • Used (8) from $1.99   


This special signature edition includes a CD that contains a searchable PDF version of the book and a sample chapter from the 10g edition, which was released in fall 2005.

This remains the defining book on the older 8i Oracle database if you are a developer ordatabase administratorwho works with Oracle-driven database applications. You will encounter wisdom on designing, developing, and administering these applications from one of the world’s foremost Oracle experts, Thomas Kyte. This book is largely inspired by the thousands of questions that Kyte has answered on his site,

The book covers every important feature and function of the 8i version of Oracle, and it is unique in the technical depth and insight that it provides on each topic. This book will show you how to expertly program with the database and exploit its feature set effectively. The result: you will build fast, effective, scalable, and secure Oracle applications.

Read More Show Less

Product Details

  • ISBN-13: 9781590595251
  • Publisher: Apress
  • Publication date: 4/22/2005
  • Series: Expert's Voice in Oracle Series
  • Edition number: 1
  • Pages: 1328
  • Product dimensions: 7.50 (w) x 9.40 (h) x 2.40 (d)

Meet the Author

Thomas Kyte is vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c. At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients.

Tom Kyte is the same "Ask Tom" whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and database administrators struggle with every day.

Read More Show Less

Table of Contents

Setting up 11
Ch. 1 Developing successful Oracle applications 19
Ch. 2 Architecture 53
Ch. 3 Locking and concurrency 101
Ch. 4 Transactions 135
Ch. 5 Redo and rollback 157
Ch. 6 Database tables 197
Ch. 7 Indexes 269
Ch. 8 Import and export 317
Ch. 9 Data loading 367
Ch. 10 Tuning strategies and tools 429
Ch. 11 Optimizer plan stability 505
Ch. 12 Analytic functions 545
Ch. 13 Materialized views 593
Ch. 14 Partitioning 627
Ch. 15 Autonomous transactions 659
Ch. 16 Dynamic SQL 699
Ch. 17 InterMedia 739
Ch. 18 C-based external procedures 771
Ch. 19 Java stored procedures 843
Ch. 20 Using object relational features 867
Ch. 21 Fine grained access control 913
Ch. 22 n-Tier authentication 963
Ch. 23 Invoker and definer rights 981
App. A Necessary supplied packages 1027
DBMS alert and DBMS PIPE 1031
DBMS application info 1042
DBMS Java 1050
DBMS Job 1059
DBMS Lock 1092
DBMS LogMNR 1097
DBMS obfuscation toolkit 1123
DBMS output 1144
DBMS profiler 1161
DBMS utility 1172
UTL file 1199
UTL raw 1229
UTL SMTP and sending mail 1231
UTL TCP 1244
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)