- Paperback: 688 pages
- Publisher: Prentice Hall; 2 edition (29 Oct 2002)
- Language English
- ISBN-10: 0130473200
- ISBN-13: 978-0130473202
- Product Dimensions: 23.9 x 17.5 x 3.6 cm
- Average Customer Review: 1.0 out of 5 stars See all reviews (1 customer review)
-
Amazon Bestsellers Rank:
2,435,933 in Books (See Top 100 in Books)
- #97 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. |
|
There is a newer edition of this item:
|
Product details |
More About the Authors
Discover books, learn about writers, and more.
Product Description
Product Description
Learn PL/SQL hands-on, through practical exercises, self-review questions and real-world answers. This book teaches all the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and our great Web-based training site! Coverage includes every key Oracle PL/SQL concept, including: the basics of structured programming; PL/SQL structure and syntax; iterative control; scoping and anchored datatypes; SQL within PL/SQL; for update cursors and subprograms; stored code, triggers, security, tables, even advanced-level package and parameter passing techniques. A free Web-based training module includes a Virtual Study Lounge where readers can interact with the author. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Oracle Developers typically learn SQL before venturing in to Oracle's PL/SQL. SQL is the foundation Language on which PL/SQL is build.
From the Back Cover
- Build Oracle PL/SQL applications—now.
- Fully updated for Oracle 9i
- No Oracle PL/SQL experience necessary.
- Real-life labs and "Test Your Thinking" Q&As
Start developing applications with Oracle PL/SQL—fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals—and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging—plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates.
Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site.
Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more:
- "Test Your Thinking" project solutions and detailed explanations
- Additional self-review exercises with instant feedback and explanations
- An exclusive Virtual Study Lounge where you can interact with other students.
Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work.
Dozens of exercises cover the real-world tasks that matter most.
Hundreds of self-review questions and answers make sure you understand.
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
1 of 2 people found the following review helpful
Format:Paperback
I bought this book as it was a workbook, it claims to take you through real life issues. The book is based on a training course in the states, but, upon opening and reading the first few pages I was instructed to go the website so that I could download the sample student database so that I could complete the lessons. The page did not exist, I emailed the publishers twice regarding this and I have not heard anything. So if you want a book as a doorstop buy it, if you want a book that offers you real life examples using a sample database, don't!!!!!
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
19 reviews
34 of 34 people found the following review helpful
Better than Oracle's Beginning SQL PL/SQL Course!
12 May 2000
Format:Paperback
I paid 2000 bucks for Oracle's classroom training, then I bought this book and guess what? This book is better! Because it also goes beyond the beginning Oracle class to cover what is in the "Program Units" class as well. As for the website, Prentice Hall changed their author url's but now they have a 'redirect' to the correct site, which happens to be (...) . Again, save your money if you have to pay for your courses yourself, this book replaces "Beginning SQL & PL/SQL", "Advanced SQL", and "Program Units". There! I just saved you (2000+1700+895)=$4595.00 plus hotel and plane fare and lost wages/vacation time!
Aunty Violet
17 of 17 people found the following review helpful
For the student without a teacher
20 April 2000
Format:Paperback
This book is excellent for someone new to programming and/or Oracle PL/SQL. The book contains one lab after another to allow the true beginner to practice concepts. Cursors, exceptions, procedures, functions, packages and triggers are all covered. Keep in mind that this is not a reference book. To learn the topics that are covered in this book you will have to work the labs. Combining this book with a reference book will set you on the right foot. As of this writing (April 20, 2000), the website for the book ( ) was not up so I can't comment on that.
12 of 12 people found the following review helpful
BEGIN IF you_are_beginner THEN dont_buy_this_book END;
22 Aug 2001
Format:Paperback
for my purposes, this book was ideal! I have a background in databases and have programed in VBA, C and normal SQL for some time. I have dabbled in PL/SQL a little bit and needed a refference book to get me going fully.
If you lack basic SQL knowledge and basic procedural programming concepts then this book won't help you very much as it assumes the reader is looking for a hands-on refference book.
one other reviewer mentioned the 'DUAL' table being introduced without explanation among other things. - 'dual' is an oracle psudo-table that you can select calculations from. e.g. "select 10 - 4 from dual" returns a column named '10 - 4' with a value of in the cell returned. anyway...
I agree with other reviewers that this book has a few errors (for example table aliases in the questions are different to those in the answers) and perhaps it could have been layed out more efficiently, but as I have said, for my purposes (quick refference book) it was Ideal.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Oracle > PL & SQL
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
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.
|
