Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
|---|---|---|---|---|---|
Searching... | 30000010242577 | QA76.73 .P258 C373 2013 | Open Access Book | Book | Searching... |
Searching... | 30000010343926 | QA76.73 .P258 C373 2013 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle11g. ORACLE 11G: PL/SQL PROGRAMMING & ORACLE CD, 2E uses Oracle 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle CD make this book is an invaluable resource in preparing for the new Oracle Certification exam or mastering the PL/SQL programming language with Oracle.
Table of Contents
| 1 Introduction to PL/SQL |
| 2 Basic PL/SQL Block Structures |
| 3 Handling Data in PL/SQL Blocks |
| 4 Cursors and Exception Handling |
| 5 Procedures |
| 6 Functions |
| 7 PL/SQL Packages |
| 8 Dependencies, Privileges, and Compilation |
| 9 Database Triggers |
| 10 Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code |
| Appendixes |
| A Tables for the Brewbean's Database |
| B Oracle Installation and Using Oracle SQL Developer |
| Online Appendixes |
| C TOAD (Tool for Oracle Application Developers) |
| D Statement Tuning |
| E SQL*Loader Utility |
| F An Introduction to Object Technology |
