Oracle Advanced PL/SQL Developer Professional Guide

Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book and ebook
Preview in Mapt

Oracle Advanced PL/SQL Developer Professional Guide

Saurabh K. Gupta

1 customer reviews
Master advanced PL/SQL concepts along with plenty of example questions for 1Z0-146 examination with this book and ebook
Mapt Subscription
FREE
$29.99/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$25.20
$59.99
$29.99 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle Advanced PL/SQL Developer Professional Guide Book Cover
Oracle Advanced PL/SQL Developer Professional Guide
$ 35.99
$ 25.20
Advanced Oracle PL/SQL Developer's Guide - Second Edition Book Cover
Advanced Oracle PL/SQL Developer's Guide - Second Edition
$ 47.99
$ 33.60
Buy 2 for $35.00
Save $48.98
Add to Cart

Book Details

ISBN 139781849687225
Paperback440 pages

Book Description

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database. Server-side PL/SQL is stored and compiled in the Oracle Database and runs within the Oracle executable. With this guide Oracle developers can work towards accomplishing Oracle 11g Advanced PL/SQL Professional certification, which is the second milestone for developers working at the Associate level.

The Oracle Advanced PL/SQL Developer Professional Guide helps you master advanced PL/SQL concepts. Besides the clear and precise explanation on advanced topics, it also contains example code and demonstrations, which gives a sense of application and usage to readers.

The book gives a deep insight that will help transform readers from mid-level programmers to professional database developers. It aims to cover the advanced features of PL/SQL for designing and optimizing PL/SQL code.

This book starts with an overview of PL/SQL as the programming database language and outlines the benefits and characteristics of the language. The book then covers the advanced features that include PL/SQL code writing using collections, tuning recommendations using result caching, implementing VPD to enforce row level security, and much more. Apart from programming, the book also dives deep into the usage of the development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.

Table of Contents

Chapter 1: Overview of PL/SQL Programming Concepts
PL/SQL—the procedural aspect
PL/SQL development environments
Procedures
Functions
PL/SQL packages
Cursors—an overview
Exception handling in PL/SQL
Managing database dependencies
Reviewing Oracle-supplied packages
Summary
Practice exercise
Chapter 2: Designing PL/SQL Code
Understanding cursor structures
Cursor variables
Subtypes
Summary
Practice exercise
Chapter 3: Using Collections
Collections—an overview
Associative arrays
Nested tables
Varray
Collections—a comparative study
PL/SQL collection methods
Manipulating collection elements
Collection initialization
Summary
Practice exercise
Chapter 4: Using Advanced Interface Methods
Understanding external routines
Executing external C programs from PL/SQL
Executing Java programs from PL/SQL
Summary
Practice exercise
Chapter 5: Implementing VPD with Fine Grained Access Control
Fine Grained Access Control
VPD implementation—outline and components
VPD implementation—demonstrations
VPD policy metadata
Policy utilities—refresh and drop
Summary
Practice exercise
Chapter 6: Working with Large Objects
Introduction to the LOB data types
Understanding the LOB data types
Creating LOB data types
Managing LOB data types
Working with the CLOB, BLOB, and BFILE data types
Migrating from LONG to LOB
Using temporary LOBs
Summary
Practice exercise
Chapter 7: Using SecureFile LOBs
Introduction to SecureFiles
Working with SecureFiles
Migration from BasicFiles to SecureFiles
Summary
Practice exercise
Chapter 8: Compiling and Tuning to Improve Performance
Native and interpreted compilation techniques
Tuning PL/SQL code
Enabling intra unit inlining
PRAGMA INLINE
Summary
Practice exercise
Chapter 9: Caching to Improve Performance
Introduction to result cache
Configuring the database for the server result cache
Implementing the result cache in SQL
Implementing result cache in PL/SQL
Summary
Practice exercise
Chapter 10: Analyzing PL/SQL Code
Track coding information
Using SQL Developer to find coding information
Determining identifier types and usages
The DBMS_METADATA package
Summary
Practice exercise
Chapter 11: Profiling and Tracing PL/SQL Code
Tracing the PL/SQL programs
Profiling the PL/SQL programs
Summary
Practice exercise
Chapter 12: Safeguarding PL/SQL Code against SQL Injection Attacks
SQL injection—an introduction
Immunizing SQL injection attacks
Testing the code for SQL injection flaws
Summary
Practice exercise

What You Will Learn

  • Get to grips with using Advanced Interface Methods
  • Learn to implement VPD with Fine Grained Access Control
  • Make use of Collections and learn data caching techniques in PL/SQL programs
  • Protect PL/SQL code from injection attacks
  • Learn to use Result caching to tune PL/SQL code
  • Demonstrate tracing and profiling features in PL/SQL
  • Get started with SecureFiles for advanced storage options

Authors

Table of Contents

Chapter 1: Overview of PL/SQL Programming Concepts
PL/SQL—the procedural aspect
PL/SQL development environments
Procedures
Functions
PL/SQL packages
Cursors—an overview
Exception handling in PL/SQL
Managing database dependencies
Reviewing Oracle-supplied packages
Summary
Practice exercise
Chapter 2: Designing PL/SQL Code
Understanding cursor structures
Cursor variables
Subtypes
Summary
Practice exercise
Chapter 3: Using Collections
Collections—an overview
Associative arrays
Nested tables
Varray
Collections—a comparative study
PL/SQL collection methods
Manipulating collection elements
Collection initialization
Summary
Practice exercise
Chapter 4: Using Advanced Interface Methods
Understanding external routines
Executing external C programs from PL/SQL
Executing Java programs from PL/SQL
Summary
Practice exercise
Chapter 5: Implementing VPD with Fine Grained Access Control
Fine Grained Access Control
VPD implementation—outline and components
VPD implementation—demonstrations
VPD policy metadata
Policy utilities—refresh and drop
Summary
Practice exercise
Chapter 6: Working with Large Objects
Introduction to the LOB data types
Understanding the LOB data types
Creating LOB data types
Managing LOB data types
Working with the CLOB, BLOB, and BFILE data types
Migrating from LONG to LOB
Using temporary LOBs
Summary
Practice exercise
Chapter 7: Using SecureFile LOBs
Introduction to SecureFiles
Working with SecureFiles
Migration from BasicFiles to SecureFiles
Summary
Practice exercise
Chapter 8: Compiling and Tuning to Improve Performance
Native and interpreted compilation techniques
Tuning PL/SQL code
Enabling intra unit inlining
PRAGMA INLINE
Summary
Practice exercise
Chapter 9: Caching to Improve Performance
Introduction to result cache
Configuring the database for the server result cache
Implementing the result cache in SQL
Implementing result cache in PL/SQL
Summary
Practice exercise
Chapter 10: Analyzing PL/SQL Code
Track coding information
Using SQL Developer to find coding information
Determining identifier types and usages
The DBMS_METADATA package
Summary
Practice exercise
Chapter 11: Profiling and Tracing PL/SQL Code
Tracing the PL/SQL programs
Profiling the PL/SQL programs
Summary
Practice exercise
Chapter 12: Safeguarding PL/SQL Code against SQL Injection Attacks
SQL injection—an introduction
Immunizing SQL injection attacks
Testing the code for SQL injection flaws
Summary
Practice exercise

Book Details

ISBN 139781849687225
Paperback440 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide Book Cover
OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
$ 35.99
$ 25.20
Instant Oracle Database and PowerShell How-to Book Cover
Instant Oracle Database and PowerShell How-to
$ 19.99
$ 14.00
Instant Pentaho Data Integration Kitchen Book Cover
Instant Pentaho Data Integration Kitchen
$ 19.99
$ 14.00
Creating your MySQL Database: Practical Design Tips and Techniques  Book Cover
Creating your MySQL Database: Practical Design Tips and Techniques
$ 11.99
$ 8.40
Designing Next Generation Web Projects with CSS3 Book Cover
Designing Next Generation Web Projects with CSS3
$ 26.99
$ 18.90
Core Data iOS Essentials Book Cover
Core Data iOS Essentials
$ 26.99
$ 18.90