Title:
OCP developer PL/SQL program units exam guide
Personal Author:
Publication Information:
New York, N.Y. : McGraw-Hill/Osborne, 2002
Physical Description:
1 CD-ROM ; 12 cm
ISBN:
9780072193367
General Note:
Accompanies text with the same title : (QA76.3 O43 2002)
Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010037692 | CP 2717 | Computer File Accompanies Open Access Book | Compact Disc Accompanies Open Access Book | Searching... |
On Order
Summary
Summary
Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam using this Oracle Press study guide. Throughout each chapter, you'll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.
Table of Contents
| Part I Language Syntax | |
| 1 Overview of PL/SQL | p. 3 |
| An Introduction to the PL/SQL Language | p. 4 |
| PL/SQL Syntax Fundamentals | p. 7 |
| Declaration Section | p. 10 |
| Processing Section | p. 15 |
| Cursors | p. 28 |
| Advanced Datatype Declaration | p. 34 |
| Exception-Handling Section | p. 37 |
| Working with Blocks | p. 40 |
| An Introduction to Program Units | p. 47 |
| Chapter Summary | p. 49 |
| Two-Minute Drill | p. 51 |
| Chapter Questions | p. 53 |
| Answers to Chapter Questions | p. 57 |
| 2 Procedures | p. 61 |
| Uses of Procedures | p. 62 |
| Creating, Altering, and Dropping Procedures | p. 66 |
| Invoking Procedures | p. 73 |
| Parameters | p. 76 |
| Data Dictionary Resources for Procedures | p. 85 |
| Chapter Summary | p. 93 |
| Two-Minute Drill | p. 95 |
| Chapter Questions | p. 96 |
| Answers to Chapter Questions | p. 100 |
| 3 Functions | p. 103 |
| Uses of Functions | p. 104 |
| Creating, Altering, and Dropping Functions | p. 106 |
| Invoking Functions | p. 109 |
| Parameters | p. 115 |
| RETURN | p. 119 |
| Chapter Summary | p. 123 |
| Two-Minute Drill | p. 123 |
| Chapter Questions | p. 124 |
| Answers to Chapter Questions | p. 129 |
| 4 Packages | p. 133 |
| Uses of Packages | p. 134 |
| Creating, Altering, and Dropping Packages | p. 137 |
| Invoking Packaged Constructs | p. 151 |
| Data Dictionary Resources for Packages | p. 156 |
| Chapter Summary | p. 158 |
| Two-Minute Drill | p. 159 |
| Chapter Questions | p. 160 |
| Answers to Chapter Questions | p. 164 |
| 5 Triggers | p. 167 |
| Uses of Triggers | p. 168 |
| Creating, Altering, and Dropping Triggers | p. 170 |
| Enabling and Disabling Triggers | p. 183 |
| Instead of Triggers | p. 185 |
| Non-DML Triggers | p. 188 |
| Data Dictionary Resources for Triggers | p. 190 |
| Chapter Summary | p. 194 |
| Two-Minute Drill | p. 195 |
| Chapter Questions | p. 197 |
| Answers to Chapter Questions | p. 200 |
| 6 Working with Program Units | p. 203 |
| Client-Side versus Server-Side Program Units | p. 204 |
| Local Subprograms | p. 209 |
| Overloading | p. 214 |
| Initializing Variables with a One-Time-Only Procedure | p. 219 |
| Functions and Purity Levels | p. 221 |
| Persistent States | p. 228 |
| Chapter Summary | p. 237 |
| Two-Minute Drill | p. 238 |
| Chapter Questions | p. 239 |
| Answers to Chapter Questions | p. 243 |
| 7 Working with Oracle's PL/SQL Packages | p. 245 |
| DBMS_OUTPUT | p. 247 |
| DBMS_JOB | p. 251 |
| DBMS_DDL | p. 257 |
| DBMS_PIPE | p. 260 |
| DBMS_SQL | p. 263 |
| Chapter Summary | p. 274 |
| Two-Minute Drill | p. 275 |
| Chapter Questions | p. 276 |
| Answers to Chapter Questions | p. 278 |
| Part II Development Tools | |
| 8 Using Oracle PL/SQL Tools | p. 283 |
| SQL *Plus | p. 284 |
| Procedure Builder | p. 292 |
| Chapter Summary | p. 310 |
| Two-Minute Drill | p. 311 |
| Chapter Questions | p. 312 |
| Answers to Chapter Questions | p. 315 |
| 9 Debugging PL/SQL | p. 317 |
| Debugging Concepts | p. 318 |
| Debugging with SQL *Plus | p. 323 |
| Debugging with Procedure Builder | p. 330 |
| Chapter Summary | p. 340 |
| Two-Minute Drill | p. 340 |
| Chapter Questions | p. 341 |
| Answers to Chapter Questions | p. 344 |
| Part III Privileges and Interdependence | |
| 10 Managing Privileges | p. 349 |
| System Privileges | p. 350 |
| Roles | p. 351 |
| System and Object Privilege Requirements for Program Units | p. 353 |
| Owner and Invoker Rights | p. 358 |
| Granting and Revoking Privileges | p. 362 |
| Data Dictionary Resources | p. 364 |
| Chapter Summary | p. 368 |
| Two-Minute Drill | p. 370 |
| Chapter Questions | p. 371 |
| Answers to Chapter Questions | p. 373 |
| 11 Managing Interdependencies | p. 377 |
| Tracking Dependencies | p. 378 |
| Dependency Issues Within a Single Database | p. 386 |
| Dependency Issues Across Multiple Databases | p. 388 |
| Avoiding Recompilation Errors | p. 392 |
| Chapter Summary | p. 394 |
| Two-Minute Drill | p. 396 |
| Chapter Questions | p. 396 |
| Answers to Chapter Questions | p. 399 |
| Part IV Practice Exams | |
| 12 Practice Exams | p. 403 |
| Practice Exam #1 | p. 404 |
| Answers to Practice Exam #1 | p. 425 |
| Practice Exam #2 | p. 436 |
| Answers to Practice Exam #2 | p. 452 |
| Practice Exam #3 | p. 462 |
| Answers to Practice Exam #3 | p. 478 |
