2014
pluralsight
Pankaj Jain
4h 1m
English
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.
01. Introduction 6:30
Overview 2:54
Prerequisites 1:03
Audience 1:05
Tools 1:27
02. Transaction Management in PL/SQL 50:09
Transaction Management in Oracle 8:22
Transaction Names & Read Only Transactions 4:41
Commits 4:18
Rollbacks & Statement Level Atomicity 3:52
Demo: Commit & Rollback 9:40
Savepoints 6:08
Demo: Savepoints 7:05
Explicit Locks 5:07
Summary 0:54
03. Autonomous Transactions 27:36
What Are Autonomous Transactions? 2:50
How to Define Autonomous Transactions 3:27
How Autonomous Transactions Work & Considerations 3:43
Need for Autonomous Transactions 4:56
Demo: Need for Autonomous Transactions 3:51
Demo: Transaction Context With Autonomous Transactions 2:29
Creating Atomic & Independent Work Units 1:29
Demo:Creating Atomic & Independent Work Units 3:37
Summary 1:10
04. Native Dynamic SQL 58:47
What Is a Dynamic SQL? 4:02
Static vs. Dynamic SQL 2:30
Common Usage Scenarios 3:21
Native Dynamic SQL Syntax Advantages & Syntax 3:09
DDL Operations 3:39
Demo: Executing DDL Statements 2:26
Executing Single Row & Multiple Row Selects 9:53
Demo: Single Row & Multi-Row Select 3:31
Executing DML Statements 5:54
Executing Anonymous Blocks, Procedures & Functions 5:33
Demo: Executing Procedures 4:17
Hints, Session Control Statements & Invokers Right 3:14
SQL Injection 3:36
Demo: SQL Injection 2:33
Summary 1:03
05. Dynamic SQL Using DBMS_SQL 1:01:12
Introduction 2:12
DBMS_SQL Workflow 3:22
Executing DDL & Session Control Statements 5:02
Demo: Executing DDL Statements 1:50
Executing DML Statements 6:03
Executing Anonymous Blocks & Subprograms 4:07
Demo: Executing Anonymous Blocks & Subprograms 1:57
Executing Select Statements 6:37
Demo: Executing Select Statements 4:20
Describing Columns 5:04
Unknown Number of Select Statements 4:23
Demo: Unknown 5:41
Security 2:18
Demo: Security 1:55
DBMS_SQL & Native Dynamic SQL Interoperability 5:11
Summary 1:04
06. Debugging PL/SQL Code 37:22
Debugging Methods 2:13
DBMS_OUTPUT 2:57
DBMS_UTILITY 2:37
Demo: DBMS_OUTPUT 6:10
Compiling for Debug 1:21
Demo: SQL Developer Debugger Setup 4:32
Demo: Debugger Views, Navigation & Debugging Exceptions 6:47
Demo: Navigating Execution Flow With Debugger 6:02
Demo: What if Analysis & Conditional Breakpoints 3:22
Summary 1:19
Download File Size:708.63 MB