Program construction-procedures, functions, blocks, packages, database triggers, and calling PL/SQL functions in SQL.Database interaction-cursors, DML and transaction management, cursor variables, and native dynamic SQL.Data structures-index-by tables, nested tables, variables arrays (VARRAYs), and object technology.Basic language elements-variables, naming, loops, conditional and sequential control, exception handling, and records.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: Exercises are provided at three levels: beginner, intermediate, and expert. 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. 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. 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 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. However excellent they are, most computer books are inherently passive-readers simply take in text without having any opportunity to react to it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |