Oracle PL/SQL: Transactions, Dynamic SQL & Debugging

In this course, we will talk in detail about transaction management in Oracle. We will take an in-depth look at dynamic SQL and debugging options in PL/SQL, and explore in detail the SQL Developer Debugger.
Course info
Rating
(62)
Level
Intermediate
Updated
Nov 20, 2014
Duration
4h 2m
Table of contents
Introduction
Transaction Management in PL/SQL
Autonomous Transactions
Native Dynamic SQL
Dynamic SQL Using DBMS_SQL
Debugging PL/SQL Code
Description
Course info
Rating
(62)
Level
Intermediate
Updated
Nov 20, 2014
Duration
4h 2m
Description

In this course, we will talk in detail about how transaction management occurs in Oracle. We will talk about transaction management commands like commits, rollbacks, and savepoints, as well as talk about naming transactions and initiating read-only transactions. Dynamic SQL helps us write extremely flexible SQL. We will talk extensively about native dynamic SQL and the DBMS_SQL package, along with the two ways to execute dynamic SQL in PL/SQL. Finally, we will dive deep into debugging methods for PL/SQL with an extensive look at the SQL Developer debugger. All of these are important concepts and skills which enable you to write efficient, accurate, and high-performing PL/SQL code.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 54m
Apr 20, 2017
More courses by Pankaj Jain