Oracle 11G PL SQL Programming 2nd Edition Casteel Test Bank
You may also like
-
$26.99
$50.00 -
$26.99
$50.00
Oracle 11G PL SQL Programming 2nd Edition Casteel Test Bank
Product details:
- ISBN:1133947360
- ISBN-13:9781133947363
- Author: Joan Casteel
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 Oracl
Oracle 11G PL SQL Programming 2nd Edition Casteel Solutions Manual
Table contents:
CH 1: INTRODUCTION TO PL/SQL
Application Programming and PL/SQL
Application Models
Oracle Resources
SQL and PL/SQL Tools
Databases Used in This Book
SQL Query Review
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 2: BASIC PL/SQL BLOCK STRUCTURES
Learning Objectives
Introduction
Programming Fundamentals
The Current Challenge in the Brewbean’s Application
PL/SQL Block Structure
Working with Variables
Decision Structures
Looping Constructs
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 3: HANDLING DATA IN PL/SQL BLOCKS
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Including a Query in a PL/SQL Block
Data Retrieval with Control Structures
Including DML Statements in a PL/SQL Block
Using Record Variables
Working with Collections
Introduction to Bulk Processing
GOTO Statements
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 4: CURSORS AND EXCEPTION HANDLING
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Working with Cursors
Bulk-Processing Features
Exception Handlers
Additional Exception Concepts
Commenting Code
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 5: PROCEDURES
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Introduction to Named Program Units
Creating a Procedure
Calling a Procedure from Another Procedure
Using the DESCRIBE Command
Using DBMS_OUTPUT to Assist in Debugging
Subprograms
Scope of Variables, Exception Handling, and Transactions
Error Handling with RAISE_APPLICATION_ERROR
Removing Procedures
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 6: FUNCTIONS
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
An Introduction to Functions
Using the OUT Parameter Mode in a Function
Multiple RETURN Statements
Actual and Formal Parameter Constraints
Function Purity Levels
Additional Program Unit Options
Data Dictionary Information on Program Units
Deleting Program Units
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 7: PL/SQL PACKAGES
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Creating Packages
Invoking Package Constructs
Forward Declarations in Packages
One-Time-Only Procedures
Overloading Program Units in Packages
Managing SQL Restrictions for Packaged Functions
Using a REF CURSOR Parameter in Packages
Granting Execute Privileges for Program Units and Packages
Data Dictionary Information for Packages
Deleting Packages
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 8: DEPENDENCIES, PRIVILEGES, AND COMPILATION
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Local Dependency Activity
Identifying Direct and Indirect Dependencies
Package Dependencies
Remote Object Dependencies
Tips to Prevent Recompilation Errors
Granting Program Unit Privileges
PL/SQL Compilation
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 9: DATABASE TRIGGERS
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Introduction to Database Triggers
Creating and Testing a DML Trigger
Creating and Testing an INSTEAD OF Trigger
Additional Triggers
Using Triggers to Address Processing Needs
Compound Triggers
Trigger-Firing Order
The ALTER TRIGGER Statement
Deleting a Trigger
Data Dictionary Information for Triggers
Chapter Summary
Review Questions
Hands-On Assignments Part I
Hands-On Assignments Part II
Case Projects
CH 10: ORACLE-SUPPLIED PACKAGES, DYNAMIC SQL, AND HIDING SOURCE CODE
Learning Objectives
Introduction
The Current Challenge in the Brewbean’s Application
Generating Output
Large Objects
Communication Capabilities
Additional Packages
Dynamic SQL and PL/SQL
Hiding Source Code
Chapter Summary
Review Questions
Hands-On Assignments
Case Project
People also search:
Oracle 11G PL SQL Programming 2nd Edition Casteel
Oracle 11G PL SQL Programming 2nd Edition pdf free
Oracle 11G PL SQL Programming 2nd Edition Casteel download
oracle database 11g pl/sql programming workbook pdf
oracle database 11g pl/sql fundamentals
