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.
What you'll learn
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.
Table of contents
- What Are Autonomous Transactions? 3m
- How to Define Autonomous Transactions 3m
- How Autonomous Transactions Work & Considerations 4m
- Need for Autonomous Transactions 5m
- Demo: Need for Autonomous Transactions 4m
- Demo: Transaction Context With Autonomous Transactions 2m
- Creating Atomic & Independent Work Units 1m
- Demo:Creating Atomic & Independent Work Units 4m
- Summary 1m
- What Is a Dynamic SQL? 4m
- Static vs. Dynamic SQL 3m
- Common Usage Scenarios 3m
- Native Dynamic SQL Syntax Advantages & Syntax 3m
- DDL Operations 4m
- Demo: Executing DDL Statements 2m
- Executing Single Row & Multiple Row Selects 10m
- Demo: Single Row & Multi-Row Select 4m
- Executing DML Statements 6m
- Executing Anonymous Blocks, Procedures & Functions 6m
- Demo: Executing Procedures 4m
- Hints, Session Control Statements & Invokers Right 3m
- SQL Injection 4m
- Demo: SQL Injection 3m
- Summary 1m
- Introduction 2m
- DBMS_SQL Workflow 3m
- Executing DDL & Session Control Statements 5m
- Demo: Executing DDL Statements 2m
- Executing DML Statements 6m
- Executing Anonymous Blocks & Subprograms 4m
- Demo: Executing Anonymous Blocks & Subprograms 2m
- Executing Select Statements 7m
- Demo: Executing Select Statements 4m
- Describing Columns 5m
- Unknown Number of Select Statements 4m
- Demo: Unknown 6m
- Security 2m
- Demo: Security 2m
- DBMS_SQL & Native Dynamic SQL Interoperability 5m
- Summary 1m
- Debugging Methods 2m
- DBMS_OUTPUT 3m
- DBMS_UTILITY 3m
- Demo: DBMS_OUTPUT 6m
- Compiling for Debug 1m
- Demo: SQL Developer Debugger Setup 5m
- Demo: Debugger Views, Navigation & Debugging Exceptions 7m
- Demo: Navigating Execution Flow With Debugger 6m
- Demo: What if Analysis & Conditional Breakpoints 3m
- Summary 1m