Oracle9i: The Complete Reference [Paperback]

Kevin Loney (Author), George Koch (Author)

Book Description

Publication Date: August 16, 2002 | ISBN-10: 0072225211 | ISBN-13: 978-0072225211 | Edition: 1

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.

Editorial Reviews

From the Back Cover

The Renowned Oracle Resource--Fully Updated for Oracle9i

Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. You'll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals.

• Use flashback queries to see data as it existed prior to commits
• Create, query, and manage external tables
• Create partitions, indexes, and tablespaces
• Execute and tune SQL queries
• Produce sophisticated reports using SQL*PLUS
• Load data from external files into Oracle database tables with SQL*Loader
• Create triggers, stored procedures, functions, and packages with PL/SQL
• Implement types, object views, and methods
• Develop robust database applications with SQLJ, JDBC, and XML
• Take advantage of the Oracle9i data dictionary and optimizer
• Tour the components of Oracle9i Application Server (Oracle9iAS)
• Manage, tune, back up, and recover Oracle9i databases
• Learn anytime, anywhere with a 90-day Oracle University Professional subscription. Details on CD-ROM

Bonus CD includes fully searchable electronic book, complete listings of all tables, and an Oracle9i "Information & Documentation Kit" featuring Release 2 New Features White Paper and selected documentation.

About the Author

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine.

Product Details

• Paperback: 1256 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (August 16, 2002)
• Language: English
• ISBN-10: 0072225211
• ISBN-13: 978-0072225211
• Product Dimensions: 9 x 7.1 x 2.4 inches
• Shipping Weight: 4.2 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #1,044,099 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

21 of 22 people found the following review helpful:

5.0 out of 5 stars Solid coverage, August 29, 2002

By A Customer

This review is from: Oracle9i: The Complete Reference (Paperback)

This is the one I've been waiting for. It's got coverage of the 9i features like external tables and updates the older chapters to include features. I hadn't even heard about multitable inserts before this book. The CD has 9i R2 docs as well as the book scripts. Overall, more in-depth coverage than the 9i New Features book but the new features are more integrated to old text so you may have to read a little more but it's worth it.

12 of 12 people found the following review helpful:

5.0 out of 5 stars Great reference, August 25, 2003

By A Customer

This review is from: Oracle9i: The Complete Reference (Paperback)

I cannot keep this book on my desk my cube and have finally ordered more copies for the rest of the crew. It is a terrific reference for anyone using or developing Oracle products. It is very well-written and contains an index that should be a model to the writers and editors of all technical manuals.

19 of 21 people found the following review helpful:

5.0 out of 5 stars The Best book to Start Learning Oracle, October 22, 2003

By 

Kalyan A Samaddar (India) - See all my reviews

This review is from: Oracle9i: The Complete Reference (Paperback)

This is the book to start learning Oracle. This book assume that you know nothing and from there it builds your Oracle Skills. Oracle is very vast but this book has nicely covered all the basic aspects of Oracle that you will need in your day to activity. No doubt that this book will not make you an Oracle Expert but definitely you will learn to move forward. This is the starting point.... This book will make your base for Oracle.