Name [pluralsight.com] Oracle PL_SQL. Transactions, Dynamic SQL & Debugging

File Type video

Size 787.02MB

UpdateDate 2024-12-8

hash *****28595FFFC07F329B26DB294589C1BF8BEA

Hot 1

Files 01 Introduction/01 01 Overview.mp4 | 4.23MB 01 Introduction/01 02 Prerequisites.mp4 | 1.54MB 01 Introduction/01 03 Audience.mp4 | 1.40MB 01 Introduction/01 04 Tools.mp4 | 2.37MB 02 Transaction Management in PL_SQL/02 01 Transaction Management in Oracle.mp4 | 17.22MB 02 Transaction Management in PL_SQL/02 02 Transaction Names & Read Only Transactions.mp4 | 8.24MB 02 Transaction Management in PL_SQL/02 03 Commits.mp4 | 8.21MB 02 Transaction Management in PL_SQL/02 04 Rollbacks & Statement Level Atomicity.mp4 | 8.47MB 02 Transaction Management in PL_SQL/02 05 Demo - Commit & Rollback.mp4 | 40.45MB 02 Transaction Management in PL_SQL/02 06 Savepoints.mp4 | 14.05MB 02 Transaction Management in PL_SQL/02 07 Demo - Savepoints.mp4 | 28.83MB 02 Transaction Management in PL_SQL/02 08 Explicit Locks.mp4 | 8.70MB 02 Transaction Management in PL_SQL/02 09 Summary.mp4 | 1.18MB 03 Autonomous Transactions/03 01 What Are Autonomous Transactions.mp4 | 4.46MB 03 Autonomous Transactions/03 02 How to Define Autonomous Transactions.mp4 | 8.10MB 03 Autonomous Transactions/03 03 How Autonomous Transactions Work & Considerations.mp4 | 9.09MB 03 Autonomous Transactions/03 04 Need for Autonomous Transactions.mp4 | 15.87MB 03 Autonomous Transactions/03 05 Demo - Need for Autonomous Transactions.mp4 | 16.23MB 03 Autonomous Transactions/03 06 Demo - Transaction Context With Autonomous Transactions.mp4 | 9.91MB 03 Autonomous Transactions/03 07 Creating Atomic & Independent Work Units.mp4 | 4.81MB 03 Autonomous Transactions/03 08 Demo -Creating Atomic & Independent Work Units.mp4 | 17.08MB 03 Autonomous Transactions/03 09 Summary.mp4 | 1.51MB 04 Native Dynamic SQL/04 01 What Is a Dynamic SQL.mp4 | 9.20MB 04 Native Dynamic SQL/04 02 Static vs. Dynamic SQL.mp4 | 4.87MB 04 Native Dynamic SQL/04 03 Common Usage Scenarios.mp4 | 4.95MB 04 Native Dynamic SQL/04 04 Native Dynamic SQL Syntax Advantages & Syntax.mp4 | 5.09MB 04 Native Dynamic SQL/04 05 DDL Operations.mp4 | 8.11MB 04 Native Dynamic SQL/04 06 Demo - Executing DDL Statements.mp4 | 12.32MB 04 Native Dynamic SQL/04 07 Executing Single Row & Multiple Row Selects.mp4 | 26.65MB 04 Native Dynamic SQL/04 08 Demo - Single Row & Multi-Row Select.mp4 | 17.58MB 04 Native Dynamic SQL/04 09 Executing DML Statements.mp4 | 12.83MB 04 Native Dynamic SQL/04 10 Executing Anonymous Blocks, Procedures & Functions.mp4 | 11.55MB 04 Native Dynamic SQL/04 11 Demo - Executing Procedures.mp4 | 29.55MB 04 Native Dynamic SQL/04 12 Hints, Session Control Statements & Invokers Right.mp4 | 6.85MB 04 Native Dynamic SQL/04 13 SQL Injection.mp4 | 8.21MB 04 Native Dynamic SQL/04 14 Demo - SQL Injection.mp4 | 11.25MB 04 Native Dynamic SQL/04 15 Summary.mp4 | 1.35MB 05 Dynamic SQL Using DBMS_SQL/05 01 Introduction.mp4 | 3.77MB 05 Dynamic SQL Using DBMS_SQL/05 02 DBMS_SQL Workflow.mp4 | 5.60MB 05 Dynamic SQL Using DBMS_SQL/05 03 Executing DDL & Session Control Statements.mp4 | 11.79MB 05 Dynamic SQL Using DBMS_SQL/05 04 Demo - Executing DDL Statements.mp4 | 7.27MB 05 Dynamic SQL Using DBMS_SQL/05 05 Executing DML Statements.mp4 | 19.12MB 05 Dynamic SQL Using DBMS_SQL/05 06 Executing Anonymous Blocks & Subprograms.mp4 | 14.48MB 05 Dynamic SQL Using DBMS_SQL/05 07 Demo - Executing Anonymous Blocks & Subprograms.mp4 | 12.25MB 05 Dynamic SQL Using DBMS_SQL/05 08 Executing Select Statements.mp4 | 17.13MB 05 Dynamic SQL Using DBMS_SQL/05 09 Demo - Executing Select Statements.mp4 | 26.51MB 05 Dynamic SQL Using DBMS_SQL/05 10 Describing Columns.mp4 | 9.80MB 05 Dynamic SQL Using DBMS_SQL/05 11 Unknown Number of Select Statements.mp4 | 15.10MB 05 Dynamic SQL Using DBMS_SQL/05 12 Demo - Unknown.mp4 | 27.75MB 05 Dynamic SQL Using DBMS_SQL/05 13 Security.mp4 | 5.29MB 05 Dynamic SQL Using DBMS_SQL/05 14 Demo - Security.mp4 | 9.77MB 05 Dynamic SQL Using DBMS_SQL/05 15 DBMS_SQL & Native Dynamic SQL Interoperability.mp4 | 13.27MB 05 Dynamic SQL Using DBMS_SQL/05 16 Summary.mp4 | 1.35MB 06 Debugging PL_SQL Code/06 01 Debugging Methods.mp4 | 3.71MB 06 Debugging PL_SQL Code/06 02 DBMS_OUTPUT.mp4 | 4.75MB 06 Debugging PL_SQL Code/06 03 DBMS_UTILITY.mp4 | 6.31MB 06 Debugging PL_SQL Code/06 04 Demo - DBMS_OUTPUT.mp4 | 31.08MB 06 Debugging PL_SQL Code/06 05 Compiling for Debug.mp4 | 2.09MB 06 Debugging PL_SQL Code/06 06 Demo - SQL Developer Debugger Setup.mp4 | 27.60MB 06 Debugging PL_SQL Code/06 07 Demo - Debugger Views, Navigation & Debugging Exceptions.mp4 | 43.62MB 06 Debugging PL_SQL Code/06 08 Demo - Navigating Execution Flow With Debugger.mp4 | 39.05MB 06 Debugging PL_SQL Code/06 09 Demo - What if Analysis & Conditional Breakpoints.mp4 | 23.13MB 06 Debugging PL_SQL Code/06 10 Summary.mp4 | 1.63MB Exercise Files/1-oracle-plsql-transactions-dynamic-sql-debugging-m1-slides.pdf | 95.49KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/.DS_Store | 12.00KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/After/.DS_Store | 6.00KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/After/drop.txt | 242B Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Before/.DS_Store | 6.00KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Before/create.txt | 1.88KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1.txt | 1.84KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1A.txt | 3.49KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2.txt | 1.47KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2a.txt | 1.85KB Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-drop.txt | 242B Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Setup.txt | 338B Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-slides.pdf | 199.88KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/.DS_Store | 6.00KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/After/.DS_Store | 6.00KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/After/drop.txt | 158B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Before/.DS_Store | 6.00KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Before/create.txt | 1.95KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1.sql | 782B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1a.sql | 871B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1b.sql | 510B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo2.sql | 807B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo3.sql | 1.36KB Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Setup.txt | 338B Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-slides.pdf | 207.42KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/.DS_Store | 6.00KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/After/.DS_Store | 6.00KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/After/drop.txt | 256B Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Before/.DS_Store | 6.00KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Before/create.txt | 3.47KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/drop.txt | 256B Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo1-ddl.txt | 795B Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo2-record.txt | 1.11KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo3-dmlproc.txt | 1.45KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo4-sqlinjection.txt | 1.02KB Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Setup.txt | 338B Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-slides.pdf | 259.20KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/.DS_Store | 15.00KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/After/.DS_Store | 6.00KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/After/drop.txt | 198B Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Before/.DS_Store | 6.00KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Before/create.txt | 2.63KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo1.txt | 489B Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo2.txt | 959B Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo3.txt | 1.09KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4a.txt | 968B Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4b.txt | 1.84KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4c.txt | 2.61KB Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Setup.txt | 338B Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-slides.pdf | 463.45KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/.DS_Store | 6.00KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/After/.DS_Store | 6.00KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/After/drop.txt | 148B Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Before/.DS_Store | 6.00KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Before/create.txt | 1.91KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo1.txt | 1.61KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo2.txt | 2.06KB Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Setup.txt | 338B Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-slides.pdf | 157.54KB