Oracle PL/SQL: Transactions, Dynamic SQL & Debugging
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction- 6m 30s
—Overview 2m 54s
—Prerequisites 1m 3s
—Audience 1m 5s
—Tools 1m 27sTransaction Management in PL/SQL- 50m 9s
—Transaction Management in Oracle 8m 22s
—Transaction Names & Read Only Transactions 4m 41s
—Commits 4m 18s
—Rollbacks & Statement Level Atomicity 3m 52s
—Demo: Commit & Rollback 9m 40s
—Savepoints 6m 8s
—Demo: Savepoints 7m 5s
—Explicit Locks 5m 7s
—Summary 0m 54sAutonomous Transactions- 27m 36sNative Dynamic SQL- 58m 47sDynamic SQL Using DBMS_SQL- 1h 1mDebugging PL/SQL Code- 37m 22s