Advanced Oracle PL/SQL Developer's Guide - Second Edition

Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c

Advanced Oracle PL/SQL Developer's Guide - Second Edition

This ebook is included in a Mapt subscription
Saurabh K. Gupta

3 customer reviews
Master the advanced concepts of PL/SQL for professional-level certification and learn the new capabilities of Oracle Database 12c
$0.00
$47.99
$59.99
$29.99p/m after trial
RRP $47.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 4,000+ eBooks & Videos
  • 40+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781785284809
Paperback428 pages

Book Description

Oracle Database is one of the most popular databases and allows users to make efficient use of their resources and to enhance service levels while reducing the IT costs incurred. Oracle Database is sometimes compared with Microsoft SQL Server, however, Oracle Database clearly supersedes SQL server in terms of high availability and addressing planned and unplanned downtime. Oracle PL/SQL provides a rich platform for application developers to code and build scalable database applications and introduces multiple new features and enhancements to improve development experience.

Advanced Oracle PL/SQL Developer's Guide, Second Edition is a handy technical reference for seasoned professionals in the database development space. This book starts with a refresher of fundamental concepts of PL/SQL, such as anonymous block, subprograms, and exceptions, and prepares you for the upcoming advanced concepts. The next chapter introduces you to the new features of Oracle Database 12c, not limited to PL/SQL. In this chapter, you will understand some of the most talked about features such as Multitenant and Database In-Memory. Moving forward, each chapter introduces advanced concepts with the help of demonstrations, and provides you with the latest update from Oracle Database 12c context. This helps you to visualize the pre- and post-applications of a feature over the database releases. By the end of this book, you will have become an expert in PL/SQL programming and will be able to implement advanced concepts of PL/SQL for efficient management of Oracle Database.

Table of Contents

Chapter 1: Overview of PL/SQL Programming Concepts
Introduction to PL/SQL
Cursors – an overview
Exception handling in PL/SQL
Creating stored procedures
Functions
A PL/SQL package
Oracle Database 12c enhancements to PL/SQL subprograms
Managing database dependencies
Reviewing Oracle-supplied packages
Oracle SQL Developer
Summary
Practice exercise
Chapter 2: Oracle 12c SQL and PL/SQL New Features
Database consolidation and the new Multitenant architecture
Oracle 12c SQL and PL/SQL new features
The Oracle Database 12c (12.1.0.2) In-Memory option
Summary
Chapter 3: Designing PL/SQL Code
Cursor structures
Cursor variables
Implicit statement results in Oracle Database 12c
Subtypes
Summary
Practice exercise
Chapter 4: Using Collections
Introduction to collections
Collection types
Associative arrays
Nested tables
Varray
Comparing the collection types
Oracle 12c enhancements to collections
PL/SQL collection methods
Summary
Practice exercise
Chapter 5: Using Advanced Interface Methods
Overview of External Procedures
Components of external procedure execution flow
Executing external C programs from PL/SQL
Securing External Procedures with Oracle Database 12c
Executing Java programs from PL/SQL
Summary
Practice exercise
Chapter 6: Virtual Private Database
Oracle Database Security overview
Fine-Grained Access Control
Virtual Private Database
Virtual Private Database metadata
Oracle Database 12c Security enhancements
Summary
Practice exercise
Chapter 7: Oracle SecureFiles
Introduction to Large Objects
LOB data types in Oracle
Oracle SecureFiles
Working with LOBs
Migrating LONG to LOBs
Migrating BasicFiles to SecureFiles
Oracle Database 12c enhancements to SecureFiles
Summary
Practice exercise
Chapter 8: Tuning the PL/SQL Code
The PL/SQL Compiler
Native and interpreted compilation techniques
Tuning PL/SQL code
Summary
Practice exercise
Chapter 9: Result Cache
Oracle Database 11g Result Cache
SQL query Result Cache
PL/SQL Function Result Cache
OCI Client results cache
The DBMS_RESULT_CACHE package
Result cache in Real Application Clusters
Summary
Practice exercise
Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code
A sample PL/SQL program
Tracking PL/SQL coding information
Determining identifier types and usages
The DBMS_METADATA package
Tracing PL/SQL programs using DBMS_TRACE
Profiling PL/SQL code
Summary
Practice exercise
Chapter 11: Safeguarding PL/SQL Code against SQL injection
What is SQL injection?
Preventing SQL injection attacks
Testing the code for SQL injection flaws
Summary
Practice exercise
Chapter 12: Working with Oracle SQL Developer
An overview of SQL Developer
Getting started with SQL Developer
SQL Developer 4.0 and 4.1 New Features
Summary

What You Will Learn

  • Learn and understand the key SQL and PL/SQL features of Oracle Database 12c
  • Understand the new Multitenant architecture and Database In-Memory option of Oracle Database 12c
  • Know more about the advanced concepts of the Oracle PL/SQL language such as external procedures, securing data using Virtual Private Database (VPD), SecureFiles, and PL/SQL code tracing and profiling
  • Implement Virtual Private Databases to prevent unauthorized data access
  • Trace, analyze, profile, and debug PL/SQL code while developing database applications
  • Integrate the new application development features of Oracle Database 12c with the current concepts
  • Discover techniques to analyze and maintain PL/SQL code
  • Get acquainted with the best practices of writing PL/SQL code and develop secure applications

Authors

Table of Contents

Chapter 1: Overview of PL/SQL Programming Concepts
Introduction to PL/SQL
Cursors – an overview
Exception handling in PL/SQL
Creating stored procedures
Functions
A PL/SQL package
Oracle Database 12c enhancements to PL/SQL subprograms
Managing database dependencies
Reviewing Oracle-supplied packages
Oracle SQL Developer
Summary
Practice exercise
Chapter 2: Oracle 12c SQL and PL/SQL New Features
Database consolidation and the new Multitenant architecture
Oracle 12c SQL and PL/SQL new features
The Oracle Database 12c (12.1.0.2) In-Memory option
Summary
Chapter 3: Designing PL/SQL Code
Cursor structures
Cursor variables
Implicit statement results in Oracle Database 12c
Subtypes
Summary
Practice exercise
Chapter 4: Using Collections
Introduction to collections
Collection types
Associative arrays
Nested tables
Varray
Comparing the collection types
Oracle 12c enhancements to collections
PL/SQL collection methods
Summary
Practice exercise
Chapter 5: Using Advanced Interface Methods
Overview of External Procedures
Components of external procedure execution flow
Executing external C programs from PL/SQL
Securing External Procedures with Oracle Database 12c
Executing Java programs from PL/SQL
Summary
Practice exercise
Chapter 6: Virtual Private Database
Oracle Database Security overview
Fine-Grained Access Control
Virtual Private Database
Virtual Private Database metadata
Oracle Database 12c Security enhancements
Summary
Practice exercise
Chapter 7: Oracle SecureFiles
Introduction to Large Objects
LOB data types in Oracle
Oracle SecureFiles
Working with LOBs
Migrating LONG to LOBs
Migrating BasicFiles to SecureFiles
Oracle Database 12c enhancements to SecureFiles
Summary
Practice exercise
Chapter 8: Tuning the PL/SQL Code
The PL/SQL Compiler
Native and interpreted compilation techniques
Tuning PL/SQL code
Summary
Practice exercise
Chapter 9: Result Cache
Oracle Database 11g Result Cache
SQL query Result Cache
PL/SQL Function Result Cache
OCI Client results cache
The DBMS_RESULT_CACHE package
Result cache in Real Application Clusters
Summary
Practice exercise
Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code
A sample PL/SQL program
Tracking PL/SQL coding information
Determining identifier types and usages
The DBMS_METADATA package
Tracing PL/SQL programs using DBMS_TRACE
Profiling PL/SQL code
Summary
Practice exercise
Chapter 11: Safeguarding PL/SQL Code against SQL injection
What is SQL injection?
Preventing SQL injection attacks
Testing the code for SQL injection flaws
Summary
Practice exercise
Chapter 12: Working with Oracle SQL Developer
An overview of SQL Developer
Getting started with SQL Developer
SQL Developer 4.0 and 4.1 New Features
Summary

Book Details

ISBN 139781785284809
Paperback428 pages
Read More
From 3 reviews

Read More Reviews