Oracle PL/SQL Developer's Workbook

Overview

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

See more details below
Paperback (New Edition)
$48.40
BN.com price
(Save 11%)$54.99 List Price
Other sellers (Paperback)
  • All (25) from $1.99   
  • New (7) from $23.99   
  • Used (18) from $1.99   
Oracle PL/SQL Developer's Workbook

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.49
BN.com price
(Save 42%)$43.99 List Price

Overview

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.

Written by one of the world's leading experts on the Oracle PL/SQL language, this text offers extensive exercises in all skill levels covering major features of the language. Also provides a primer to the PL/SQL language.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Know some Oracle PL/SQL? Want to become far more fluent with the language, quick — confident that you can take on any project that comes at you? Check out Oracle PL/SQL Programming Developer's Workbook. Steven Feuerstein wrote this book with the goal of actively engaging you, provoking a response, and getting you to solve problems you might not otherwise have dared to try. He succeeds.

The organization of the book is excellent. Problems in the first half, solutions in the second half — so you don't "stumble across" Feuerstein's answers before you've had a chance to come up with your own. Within each chapter, exercises are organized by level of experience, so you can go straight to "beginner," "intermediate," or "expert" problems — and also get an objective idea of where you really stand.

Feuerstein opens with language fundamentals: declaring variables and naming elements; loops; conditional and sequential control; and records. Next, he presents challenges associated with data structures: index-by tables, nested tables, variable arrays, and object technology. In Part III, Feuerstein helps you deepen your understanding of database interaction: cursors, DML, transaction management, cursor variables, and native dynamic SQL.

The book includes extensive coverage of program construction, Oracle PL/SQL's built-in functionality; and more — including a chapter on Java stored procedures, one on tuning and one on web development.

Whatever other PL/SQL book youmayalready own, this one will help you deepen your understanding as never before. With this book, you can really make PL/SQL yours.


bncom editor

Read More Show Less

Product Details

  • ISBN-13: 9781565926745
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 5/28/2000
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 594
  • Product dimensions: 7.01 (w) x 9.17 (h) x 1.20 (d)

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

Read More Show Less

Table of Contents

Preface

Part I: Problems

Chapter 1: Declaring Variables and Naming Elements

Chapter 2: Loops

Chapter 3: Conditional and Sequential Logic

Chapter 4: Exception Handling

Chapter 5: Records

Chapter 6: Index-by Tables

Chapter 7: Nested Tables

Chapter 8: Variable Arrays

Chapter 9: Object Technology

Chapter 10: Cursors

Chapter 11: DML and Transaction Management

Chapter 12: Cursor Variables

Chapter 13: Native Dynamic SQL

Chapter 14: Procedures, Functions, and Blocks

Chapter 15: Packages

Chapter 16: Triggers

Chapter 17: Calling Functions in SQL

Chapter 18: Character Functions

Chapter 19: Date Functions

Chapter 20: Conversion, Numeric, and Miscellaneous Functions

Chapter 21: DBMS_SQL Built-in Package

Chapter 22: DBMS_PIPE Built-in Package

Chapter 23: DBMS_OUTPUT Built-in Package

Chapter 24: UTL_FILE Built-in Package

Chapter 25: DBMS_JOB Built-in Package

Chapter 26: Using Java with PL/SQL

Chapter 27: External Procedures

Chapter 28: PL/SQL Web Development

Chapter 29: Tuning PL/SQL

Chapter 30: PL/SQL for DBAs

Part II: Solutions

Chapter 1: Declaring Variables and Naming Elements

Chapter 2: Loops

Chapter 3: Conditional and Sequential Logic

Chapter 4: Exception Handling

Chapter 5: Records

Chapter 6: Index-by Tables

Chapter 7: Nested Tables

Chapter 8: Variable Arrays

Chapter 9: Object Technology

Chapter 10: Cursors

Chapter 11: DML and Transaction Management

Chapter 12: Cursor Variables

Chapter 13: Native Dynamic SQL

Chapter 14: Procedures, Functions, and Blocks

Chapter 15: Packages

Chapter 16: Triggers

Chapter 17: Calling Functions in SQL

Chapter 18: Character Functions

Chapter 19: Date Functions

Chapter 20: Conversion, Numeric, and Miscellaneous Functions

Chapter 21: DBMS_SQL Built-in Package

Chapter 22: DBMS_PIPE Built-in Package

Chapter 23: DBMS_OUTPUT Built-in Package

Chapter 24: UTL_FILE Built-in Package

Chapter 25: DBMS_JOB Built-in Package

Chapter 26: Using Java with PL/SQL

Chapter 27: External Procedures

Chapter 28: PL/SQL Web Development

Chapter 29: Tuning PL/SQL

Chapter 30: PL/SQL for DBAs

Colophon

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)