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.
|
- Title:
- Oracle PL/SQL Programming: A Developer's Workbook
- By:
- Steven Feuerstein, Andrew Odewahn
- Publisher:
- O'Reilly Media
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- May 2000
- Ebook:
- June 2009
- Pages:
- 594
- Print ISBN:
- 978-1-56592-674-5
- | ISBN 10:
- 1-56592-674-9
- Ebook ISBN:
- 978-0-596-55977-9
- | ISBN 10:
- 0-596-55977-1
|
-
Steven Feuerstein 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. View Steven Feuerstein's full profile page. -
Andrew Odewahn 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. View Andrew Odewahn's full profile page. |
Colophon Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The insect on the cover of Oracle PL /SQL Developer s Workbook is a stag beetle (lucanus cervus). The stag beetle is a large, dark, tough beetle that is the largest insect in Britain. It gets its name from the male s elk-like antlers on its head, which can be as long as the body itself. These "antlers," which are actually part of the jaw and are called mandibles, are used to fight with other males, usually for a female and sometimes for food. The stag beetle has thin, fragile wings that fold under the shell of its body. In order to fly, this shell lifts, the wings unfold, and the beetle flies awkwardly. It can also rub its wings together to make a sound that s intimidating to other insects. Stag beetles feed on plant secretions, fruit, decaying wood, and wood sap, and thus prefer a habitat of trees and vegetation. The stag beetle is widespread in parts of England but is now far less common in Japan than it once was. This beetle s numbers are declining, and it is even on the endangered species list in some areas. Reasons for the diminishing numbers include loss of habitat, climate changes, collectors, and being killed by cars on the roads or by people stepping on them (whether accidentally or purposefully). Mary Anne Weeks Mayo was the copyeditor and production editor for Oracle PL/SQL Developer s Workbook. Maureen Dempsey and Emily Quill proofread the book. Mary Sheehan, Jeff Holcomb, Melanie Wang, and Jane Ellin provided quality control. Anna Snow and Judy Hoer provided production support. Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with Quark XPress 3.3 using Adobe s ITC Garamond font. The cover layout was produced with Quark XPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKover(TM), a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The interior layouts were designed by Alicia Cech and David Futato. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in this book were produced by Robert Romano and Rhon Porter using Macromedia Freehand 8 and Adobe Photoshop 5. This colophon was written by Nicole Arigo. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
Colophon
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By J.D. "Illiad" Frazer
September 1999
By J.P. Hamilton
July 2000
By Dave Grundgeiger
October 2000
|
Customer Reviews
10/6/2008 (1 of 2 customers found this review helpful) 4.0Beyond the PL/SQL code By domore from Undisclosed 1/27/2004 (4 of 5 customers found this review helpful) 5.0Oracle PL/SQL Developer's Workbook Review 6/3/2002 (2 of 2 customers found this review helpful) 4.0Oracle PL/SQL Developer's Workbook Review By RamPrasad Suswaram from Undisclosed 4/18/2002 (2 of 2 customers found this review helpful) 5.0Oracle PL/SQL Developer's Workbook Review By Suddha Satta Ray from Undisclosed 9/21/2000 (2 of 3 customers found this review helpful) 5.0Oracle PL/SQL Developer's Workbook Review By Robert Klaus from Undisclosed 7/12/2000 (3 of 4 customers found this review helpful) 4.0Oracle PL/SQL Developer's Workbook Review By Mohammed Iqbal Hussain from Undisclosed
|
|
|