Oracle PL/SQL Programming: A Developer's Workbook (Development Workbook) (Paperback)

by Steven Feuerstein (Author), Andrew Odewahn (Author)
Key Phrases: dictionary file, object technology, transaction management, Developer's Workbook, Built-in Package, Oracle Forms (more...)

Editorial Reviews

Product Description
The Oracle PL/SQL Developer's Workbook is a companion to Steven Feuerstein's bestselling Oracle PL/SQL Programming and his other PL/SQL books from O'Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer--both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds). The workbook covers:

Basic language elements--variables, naming, loops, conditional and sequential control, exception handling, and records.Data structures--index-by tables, nested tables, variables arrays (VARRAYs), and object technology.Database interaction--cursors, DML and transaction management, cursor variables, and native dynamic SQLProgram construction--procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL.Built-in functionality--the character, date, conversion, numeric, and miscellaneous functions, and the DBMS_SQL, DBMS_PIPE, DBMS_OUTPUT, UTL_FILE, and DBMS_JOB built-in packages.Miscellaneous topics--using Java with PL/SQL, external programs, PL/SQL web development, tuning PL/SQL, and PL/SQL for DBAs.

About the Author
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly & Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Andrew Odewahn is a writer and software entrepreneur. With an MBA from New York University's Stern School of Business, he has an exceptional ability to find creative yet practical solutions to real-life business problems. The author of Oracle Web Applications (O'Reilly, 1999) and co-author of Oracle PL/SQL Workbook (O'Reilly, 2000), Andrew specializes in database technology. While not writing or designing software, he and his wife travel whenever they can. Their adventures include riding Lipizzaner stallions at a Slovenian casino, speeding down an alpine slide deep in the jungles of Vietnam, hiking (and riding the occasional ski lift!) across the Swiss Alps, hosteling in a Soviet-era sanitarium, and circumnavigating New Zealand's "Mount Doom." They currently live in Maine.

Product Details

• Paperback: 592 pages
• Publisher: O'Reilly Media, Inc.; 1 edition (May 1, 2000)
• Language: English
• ISBN-10: 1565926749
• ISBN-13: 978-1565926745
• Product Dimensions: 9.1 x 7 x 1.3 inches
• Shipping Weight: 2.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars See all reviews (6 customer reviews)
• Amazon.com Sales Rank: #600,539 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #57 in

  Books > Computers & Internet > Databases > Oracle > PL & SQL

Customer Reviews

Most Helpful Customer Reviews

20 of 20 people found the following review helpful:

4.0 out of 5 stars Oracle Pl/Sql Programming Developer's, June 7, 2000

By	Gojo (canada) - See all my reviews

Only a few book can jump start you to another level, and this is one of them. Great to learn and work for newbie and even experienced pl/sql developers.

17 of 17 people found the following review helpful:

4.0 out of 5 stars The prefect second PL/SQL book, June 27, 2000

By A Customer

This is a great book to test your PL/SQL knowledge no matter what level you are at. In fact each chapter is devided into 3 sections: Beginner, Intermediate and Expert. This is an excellent book to get after you have worked through a PL/SQL course and want something to give you the extra edge on all the various PL/SQL topics. There is some very good hard to find information in here.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Great Book with Helpful Learning Exercises, June 1, 2001

By A Customer

I thought this book was great. If you like getting into specific, real-world programming tasks and figuring out the best solutions then this book is for you. He provides helpful explainations along with his solutions. There are a lot of top-notch, practical techniques that you learn as you get into the nitty-gritty of working on small pieces of pl/sql code. There are also questions that test your conceptual understanding of different facets of pl/sql programming --- questions that you could face on a job interview. Even though I've been a pl/sql developer for a few years, I found this book very useful.