Book

Advanced Oracle PL/SQL Developer's Guide

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

14h16m

Language

English

About Book

Who Is This Book For?

This book is for Oracle developers responsible for database management. Readers are expected to have basic knowledge of Oracle Database and the fundamentals of PL/SQL programming. Certification aspirants can use this book to prepare for 1Z0-146 examination in order to be an Oracle Certified Professional in Advanced PL/SQL.

Book content

chapters 14h16m total length

PLSQL Programming Concepts

Oracle 12c SQL and PLSQL New Features

Designing PLSQL Code

Using Collections

Using Advanced Interface Methods

Virtual Private Database

Working with Large Objects and SecureFiles

Tuning the PLSQL Code

Result Cache

Analyzing Profiling Tracing PLSQL Code

Protect PLSQL Code from SQL Injection

Oracle SQL Developer 4.1

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required