+612 9045 4394
Oracle PL/SQL Developer's Workbook : Developer's Workbook - Steven Feuerstein

Oracle PL/SQL Developer's Workbook

Developer's Workbook

Paperback Published: 12th May 2000
ISBN: 9781565926745
Number Of Pages: 592

Share This Book:


RRP $88.00
Ships in 15 business days

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.

Prefacep. xi
Problemsp. 1
Declaring Variables and Naming Elementsp. 3
Loopsp. 7
Conditional and Sequential Logicp. 14
Exception Handlingp. 19
Recordsp. 35
Index-by Tablesp. 43
Nested Tablesp. 51
Variable Arraysp. 61
Object Technologyp. 71
Cursorsp. 80
DML and Transaction Managementp. 90
Cursor Variablesp. 98
Native Dynamic SQLp. 105
Procedures, Functions, and Blocksp. 111
Packagesp. 117
Triggersp. 127
Calling Functions in SQLp. 135
Character Functionsp. 141
Date Functionsp. 147
Conversion, Numeric, and Miscellaneous Functionsp. 151
DBMS_SQL Built-in Packagep. 156
DBMS_PIPE Built-in Packagep. 167
DBMS_OUTPUT Built-in Packagep. 174
UTL_FILE Built-in Packagep. 179
DBMS_JOB Built-in Packagep. 187
Using Java with PL/SQLp. 191
External Proceduresp. 199
PL/SQL Web Developmentp. 204
Tuning PL/SQLp. 211
PL/SQL for DBAsp. 222
Solutionsp. 239
Declaring Variables and Naming Elementsp. 241
Loopsp. 246
Conditional and Sequential Logicp. 253
Exception Handlingp. 259
Recordsp. 277
Index-by Tablesp. 286
Nested Tablesp. 295
Variable Arraysp. 307
Object Technologyp. 319
Cursorsp. 331
DML and Transaction Managementp. 340
Cursor Variablesp. 349
Native Dynamic SQLp. 357
Procedures, Functions, and Blocksp. 364
Packagesp. 377
Triggersp. 398
Calling Functions in SQLp. 408
Character Functionsp. 414
Date Functionsp. 427
Conversion, Numeric, and Miscellaneous Functionsp. 435
DBMS_SQL Built-in Packagep. 443
DBMS_PIPE Built-in Packagep. 464
DBMS_OUTPUT Built-in Packagep. 477
UTL_FILE Built-in Packagep. 485
DBMS_JOB Built-in Packagep. 498
Using Java with PL/SQLp. 510
External Proceduresp. 518
PL/SQL Web Developmentp. 531
Tuning PL/SQLp. 544
PL/SQL for DBAsp. 554
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9781565926745
ISBN-10: 1565926749
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 592
Published: 12th May 2000
Publisher: John Wiley & Sons Publishers
Country of Publication: US
Dimensions (cm): 23.5 x 18.42  x 3.18
Weight (kg): 0.95