- Paperback: 656 pages
- Publisher: Osborne/McGraw-Hill; 2nd Revised edition edition (1 Oct 2001)
- Language English
- ISBN-10: 0072132183
- ISBN-13: 978-0072132182
- Product Dimensions: 23.1 x 18.8 x 3.8 cm
- Average Customer Review: 1.0 out of 5 stars See all reviews (1 customer review)
-
Amazon Bestsellers Rank:
2,750,807 in Books (See Top 100 in Books)
- #100 in Books > Computers & Internet > Computer Science > Databases > Applications > Oracle > PL & SQL
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Authors
Discover books, learn about writers, and more.
Product Description
Product Description
This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and "Programmer's Notes" and "Annotations" that provide expert explanations on the scripts and how they can be customized.
From the Back Cover
Perform Database and Application Management Tasks Efficiently
Access a handpicked collection of essential, ready-to-run scripts to help you develop PL/SQL solutions more quickly and easily than you ever imagined. Verify performance, obtain information about characteristics, simplify management of database objects and users, and more all through the use of preassembled scripts. Plus, expert authors supplement the scripts with in-depth explanations that will help you understand the behaviors created and even extend usage through customization. Organized by function, this book provides a thorough collection of fully documented SQL and PL/SQL scripts, including a display of sample results to help you analyze and optimize your applications.
-Use ready-to-run code to develop instant Oracle solutions
-Develop and deploy custom PL/SQL applications
-Write for Oracle7 Release 7.x, Oracle8 Release 8.x, Oracle8i, and Oracle9i
-Learn to performance-tune applications and use diagnostic scripts
-Discover native dynamic SQL options available as of Oracle8i
-Understand subpartitions, reverse indexes, iots, and materialized views
-Utilize random number generators while managing data
-Optimize shared memory usage in the System Global Area
-Manage databases, users, storage, and more
-Manage Java in the database
CD-ROM contains major scripts from the book and bonus chapters with additional scripts including a full chapter on managing Java in the database
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
7 of 8 people found the following review helpful
Format:Paperback
I liked the title of this book, all the words matched what I was looking for. Unfortunately the scripts provided are DBA scripts and not developer scripts. Most of the scripts are redundant if you have a tool such at Toad. The book is padded out to the extreme explaining how each script works in minute detail when really a small write-up of each script would be more than enough. I don't know who this book is aimed at - it has DBA scripts so maybe a DBA, but then it explains such low level detail so maybe the novice developer ? - Bafled - well at least I expensed the book so I havn't lost any money.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
1 review
9 of 11 people found the following review helpful
Starter kit for new DBAs
5 Jun 2002
Format:Paperback
This collection of scripts is a great starter kit for new DBAs because it contains highly useful code for nearly all of the basic administration, tuning and troubleshooting tasks encountered on the job.
What I like is this isn't just a collection of code on a CD ROM, but each script is carefully explained in the text of the book. For someone like myself who is still in OCP training the explanations are almost as valuable as the code. Although the title claims that the scripts are for Oracle 9i, they also work with 8i, and the book covers what modifications (if any) need to be made to use each script in earlier versions of Oracle.
Was this review helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
