OCP Developer PL/SQL Program Units Exam Guide

ISBN-10: 0072193360

ISBN-13: 9780072193367

Edition: 2002

Authors: Steve O'Hearn

List price: $59.00
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description:

The only Oracle Application Developer certification exam preparation book available for this exam.
eBooks Starting from $59.00
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $59.00
Copyright year: 2002
Publisher: McGraw-Hill Osborne
Publication date: 5/14/2002
Binding: Paperback
Pages: 499
Size: 7.00" wide x 8.75" long x 1.25" tall
Weight: 2.398
Language: English

Joseph Phillips, PMP, CompTIA Project+, CompTIA CTT+, a leading project management consultant and educator, has been a PMP and a CompTIA Certified Technical trainer for more than 12 years. He is the director of education for Project Seminars, Inc., and the bestselling author of several books, including PMP Project Management Professional Study Guide, Fourth Edition and CompTIA CTT+ Certified Technical Trainer All-in-One Exam Guide.Editor Admir Hadzic, MD, PhD Professor of Anesthesiology Department of Anesthesiology St. Luke's-Roosevelt Hospital Center College of Physicians & Surgeons Columbia University New York, New York Associate Editors Ana Carrera, PhD, MD Thomas B. Clark, DC, RVT Jeff Gadsden, MD, FRCPC, FANZCA Manoj Kumar Karmakar, MD, FRCA, FHKCA, FHKAM Xavier Sala-Blanch, MD Catherine F.M. Vandepitte, MD Daquan Xu, MD, MSc, MPHSteve O’Hearn, OCP (Bowie, MD) has been an Oracle Certified Application Developer since 1999 and has designed databases for the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He is the author of OCP Developer PL/SQL Program Units Exam Guide and OCA Oracle Database SQL Certified Expert Exam Guide, both from Oracle Press.

Language Syntax
Overview of PL/SQL
An Introduction to the PL/SQL Language
PL/SQL Syntax Fundamentals
Declaration Section
Processing Section
Cursors
Advanced Datatype Declaration
Exception-Handling Section
Working with Blocks
An Introduction to Program Units
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Procedures
Uses of Procedures
Creating, Altering, and Dropping Procedures
Invoking Procedures
Parameters
Data Dictionary Resources for Procedures
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Functions
Uses of Functions
Creating, Altering, and Dropping Functions
Invoking Functions
Parameters
RETURN
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Packages
Uses of Packages
Creating, Altering, and Dropping Packages
Invoking Packaged Constructs
Data Dictionary Resources for Packages
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Triggers
Uses of Triggers
Creating, Altering, and Dropping Triggers
Enabling and Disabling Triggers
Instead of Triggers
Non-DML Triggers
Data Dictionary Resources for Triggers
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Working with Program Units
Client-Side versus Server-Side Program Units
Local Subprograms
Overloading
Initializing Variables with a One-Time-Only Procedure
Functions and Purity Levels
Persistent States
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Working with Oracle's PL/SQL Packages
DBMS_OUTPUT
DBMS_JOB
DBMS_DDL
DBMS_PIPE
DBMS_SQL
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Development Tools
Using Oracle PL/SQL Tools
SQL *Plus
Procedure Builder
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Debugging PL/SQL
Debugging Concepts
Debugging with SQL *Plus
Debugging with Procedure Builder
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Privileges and Interdependence
Managing Privileges
System Privileges
Roles
System and Object Privilege Requirements for Program Units
Owner and Invoker Rights
Granting and Revoking Privileges
Data Dictionary Resources
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Managing Interdependencies
Tracking Dependencies
Dependency Issues Within a Single Database
Dependency Issues Across Multiple Databases
Avoiding Recompilation Errors
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Practice Exams
Practice Exams
Practice Exam #1
Answers to Practice Exam #1
Practice Exam #2
Answers to Practice Exam #2
Practice Exam #3
Answers to Practice Exam #3
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×