Oracle PL/SQL Programming: A Developer's Workbook
Publisher: O'Reilly Media
Released: May 2000
Pages: 594

However excellent they are, most computer books are inherently passive--readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer's Workbook is a different kind of animal! It's designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you've learned about PL/SQL--and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you'll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.

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).

You'll find chapters on:

  • 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 SQL
  • Program 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.
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyOracle PL/SQL Programming: A Developer's Workbook
 
4.5

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 6 customers

Sort by

Displaying reviews 1-6

Back to top

(1 of 2 customers found this review helpful)

 
4.0

Beyond the PL/SQL code

By domore

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

Great! Oracle has strengths in Forms and Reports. But when it comes PL/SQL, there is no interface. This refers to programming user defined multiple table relational processes, not stored procedures. The book could do well to cover this, such as:

http;//www.supertime2000.com/snapproc.htm

Even a novice can get up and started PL/SQL applying this.

(4 of 5 customers found this review helpful)

 
5.0

Oracle PL/SQL Developer's Workbook Review

By Jon

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

This book is very useful for understanding of pl/sql databases. In this Developer's Workbook I have found answers to all of these questions about Oracle pl/sql.

Jon

(2 of 2 customers found this review helpful)

 
4.0

Oracle PL/SQL Developer's Workbook Review

By RamPrasad Suswaram

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

A real good book for fine tunning one's understanding of pl/sql. Going through the questions in this book before I gave my first 2 exams of 'OCP Application Developer Track' made me confident enough to face the exams with ease.

(2 of 2 customers found this review helpful)

 
5.0

Oracle PL/SQL Developer's Workbook Review

By Suddha Satta Ray

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

If there is any book which will "fine-tune" one's knowledge of PL/SQL, this is it. It is written in Feuerstein's inimitable style which will keep you engaged with the book much longer than any other peer book of it's kind. There is so much to learn from this book really - and it applies to beginners as experts alike. This book explores the tiniest nuts and bolts of PL/SQL in an exercise-like format which gives the reader a chance to ponder on the problem before he/she looks up the answers. And I must add, you are in store for a lot of surprises when you look up the answers in the second half of the book ! (escpecially in the experts' section). A must-buy.

(2 of 3 customers found this review helpful)

 
5.0

Oracle PL/SQL Developer's Workbook Review

By Robert Klaus

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

At first, I didn't like the format of the book. It has a section for questions and another for the answers. I didn't want to have to keep two bookmarks just to read the book.

However, after spending a few days with it, I began noticing that I was learning a lot without trying to digest a lot of boring information. The questions made me think about what really happens and the answers give a great deal of information without a great deal of text.

Very thought provoking. It's like a journey of discovery rather than a classroom lecture.

(3 of 4 customers found this review helpful)

 
4.0

Oracle PL/SQL Developer's Workbook Review

By Mohammed Iqbal Hussain

from Undisclosed

Comments about oreilly Oracle PL/SQL Programming: A Developer's Workbook:

This book is very good I wish If we have CD with this book.so it will be more help full.

HUSSAIN.

Displaying reviews 1-6

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $43.99
Formats:  ePub, Mobi, PDF
Print & Ebook: $60.49
Print: $54.99