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

File Name

Size

01 Introduction/01 01 Overview.mp4

4.2 MB

01 Introduction/01 02 Prerequisites.mp4

1.5 MB

01 Introduction/01 03 Audience.mp4

1.4 MB

01 Introduction/01 04 Tools.mp4

2.4 MB

02 Transaction Management in PL_SQL/02 01 Transaction Management in Oracle.mp4

17 MB

02 Transaction Management in PL_SQL/02 02 Transaction Names & Read Only Transactions.mp4

8.2 MB

02 Transaction Management in PL_SQL/02 03 Commits.mp4

8.2 MB

02 Transaction Management in PL_SQL/02 04 Rollbacks & Statement Level Atomicity.mp4

8.5 MB

02 Transaction Management in PL_SQL/02 05 Demo - Commit & Rollback.mp4

40 MB

02 Transaction Management in PL_SQL/02 06 Savepoints.mp4

14 MB

02 Transaction Management in PL_SQL/02 07 Demo - Savepoints.mp4

29 MB

02 Transaction Management in PL_SQL/02 08 Explicit Locks.mp4

8.7 MB

02 Transaction Management in PL_SQL/02 09 Summary.mp4

1.2 MB

03 Autonomous Transactions/03 01 What Are Autonomous Transactions.mp4

4.5 MB

03 Autonomous Transactions/03 02 How to Define Autonomous Transactions.mp4

8.1 MB

03 Autonomous Transactions/03 03 How Autonomous Transactions Work & Considerations.mp4

9.1 MB

03 Autonomous Transactions/03 04 Need for Autonomous Transactions.mp4

16 MB

03 Autonomous Transactions/03 05 Demo - Need for Autonomous Transactions.mp4

16 MB

03 Autonomous Transactions/03 06 Demo - Transaction Context With Autonomous Transactions.mp4

9.9 MB

03 Autonomous Transactions/03 07 Creating Atomic & Independent Work Units.mp4

4.8 MB

03 Autonomous Transactions/03 08 Demo -Creating Atomic & Independent Work Units.mp4

17 MB

03 Autonomous Transactions/03 09 Summary.mp4

1.5 MB

04 Native Dynamic SQL/04 01 What Is a Dynamic SQL.mp4

9.2 MB

04 Native Dynamic SQL/04 02 Static vs. Dynamic SQL.mp4

4.9 MB

04 Native Dynamic SQL/04 03 Common Usage Scenarios.mp4

4.9 MB

04 Native Dynamic SQL/04 04 Native Dynamic SQL Syntax Advantages & Syntax.mp4

5.1 MB

04 Native Dynamic SQL/04 05 DDL Operations.mp4

8.1 MB

04 Native Dynamic SQL/04 06 Demo - Executing DDL Statements.mp4

12 MB

04 Native Dynamic SQL/04 07 Executing Single Row & Multiple Row Selects.mp4

27 MB

04 Native Dynamic SQL/04 08 Demo - Single Row & Multi-Row Select.mp4

18 MB

04 Native Dynamic SQL/04 09 Executing DML Statements.mp4

13 MB

04 Native Dynamic SQL/04 10 Executing Anonymous Blocks, Procedures & Functions.mp4

12 MB

04 Native Dynamic SQL/04 11 Demo - Executing Procedures.mp4

30 MB

04 Native Dynamic SQL/04 12 Hints, Session Control Statements & Invokers Right.mp4

6.8 MB

04 Native Dynamic SQL/04 13 SQL Injection.mp4

8.2 MB

04 Native Dynamic SQL/04 14 Demo - SQL Injection.mp4

11 MB

04 Native Dynamic SQL/04 15 Summary.mp4

1.3 MB

05 Dynamic SQL Using DBMS_SQL/05 01 Introduction.mp4

3.8 MB

05 Dynamic SQL Using DBMS_SQL/05 02 DBMS_SQL Workflow.mp4

5.6 MB

05 Dynamic SQL Using DBMS_SQL/05 03 Executing DDL & Session Control Statements.mp4

12 MB

05 Dynamic SQL Using DBMS_SQL/05 04 Demo - Executing DDL Statements.mp4

7.3 MB

05 Dynamic SQL Using DBMS_SQL/05 05 Executing DML Statements.mp4

19 MB

05 Dynamic SQL Using DBMS_SQL/05 06 Executing Anonymous Blocks & Subprograms.mp4

14 MB

05 Dynamic SQL Using DBMS_SQL/05 07 Demo - Executing Anonymous Blocks & Subprograms.mp4

12 MB

05 Dynamic SQL Using DBMS_SQL/05 08 Executing Select Statements.mp4

17 MB

05 Dynamic SQL Using DBMS_SQL/05 09 Demo - Executing Select Statements.mp4

26 MB

05 Dynamic SQL Using DBMS_SQL/05 10 Describing Columns.mp4

9.8 MB

05 Dynamic SQL Using DBMS_SQL/05 11 Unknown Number of Select Statements.mp4

15 MB

05 Dynamic SQL Using DBMS_SQL/05 12 Demo - Unknown.mp4

28 MB

05 Dynamic SQL Using DBMS_SQL/05 13 Security.mp4

5.3 MB

05 Dynamic SQL Using DBMS_SQL/05 14 Demo - Security.mp4

9.8 MB

05 Dynamic SQL Using DBMS_SQL/05 15 DBMS_SQL & Native Dynamic SQL Interoperability.mp4

13 MB

05 Dynamic SQL Using DBMS_SQL/05 16 Summary.mp4

1.3 MB

06 Debugging PL_SQL Code/06 01 Debugging Methods.mp4

3.7 MB

06 Debugging PL_SQL Code/06 02 DBMS_OUTPUT.mp4

4.8 MB

06 Debugging PL_SQL Code/06 03 DBMS_UTILITY.mp4

6.3 MB

06 Debugging PL_SQL Code/06 04 Demo - DBMS_OUTPUT.mp4

31 MB

06 Debugging PL_SQL Code/06 05 Compiling for Debug.mp4

2.1 MB

06 Debugging PL_SQL Code/06 06 Demo - SQL Developer Debugger Setup.mp4

28 MB

06 Debugging PL_SQL Code/06 07 Demo - Debugger Views, Navigation & Debugging Exceptions.mp4

44 MB

06 Debugging PL_SQL Code/06 08 Demo - Navigating Execution Flow With Debugger.mp4

39 MB

06 Debugging PL_SQL Code/06 09 Demo - What if Analysis & Conditional Breakpoints.mp4

23 MB

06 Debugging PL_SQL Code/06 10 Summary.mp4

1.6 MB

Exercise Files/1-oracle-plsql-transactions-dynamic-sql-debugging-m1-slides.pdf

96 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/.DS_Store

12 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/After/.DS_Store

6.0 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/After/drop.txt

242 B

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Before/.DS_Store

6.0 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Before/create.txt

1.9 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1.txt

1.8 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1A.txt

3.5 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2.txt

1.5 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2a.txt

1.9 kB

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-drop.txt

242 B

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Setup.txt

338 B

Exercise Files/2-oracle-plsql-transactions-dynamic-sql-debugging-m2-slides.pdf

200 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/.DS_Store

6.0 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/After/.DS_Store

6.0 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/After/drop.txt

158 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Before/.DS_Store

6.0 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Before/create.txt

2.0 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1.sql

782 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1a.sql

871 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1b.sql

510 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo2.sql

807 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo3.sql

1.4 kB

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Setup.txt

338 B

Exercise Files/3-oracle-plsql-transactions-dynamic-sql-debugging-m3-slides.pdf

207 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/.DS_Store

6.0 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/After/.DS_Store

6.0 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/After/drop.txt

256 B

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Before/.DS_Store

6.0 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Before/create.txt

3.5 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/drop.txt

256 B

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo1-ddl.txt

795 B

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo2-record.txt

1.1 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo3-dmlproc.txt

1.4 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/oracle-plsql-fundamentals-m4-demo4-sqlinjection.txt

1.0 kB

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Setup.txt

338 B

Exercise Files/4-oracle-plsql-transactions-dynamic-sql-debugging-m4-slides.pdf

259 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/.DS_Store

15 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/After/.DS_Store

6.0 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/After/drop.txt

198 B

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Before/.DS_Store

6.0 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Before/create.txt

2.6 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo1.txt

489 B

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo2.txt

959 B

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.1 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4a.txt

968 B

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.8 kB

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.6 kB

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Setup.txt

338 B

Exercise Files/5-oracle-plsql-transactions-dynamic-sql-debugging-m5-slides.pdf

463 kB

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/.DS_Store

6.0 kB

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/After/.DS_Store

6.0 kB

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/After/drop.txt

148 B

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Before/.DS_Store

6.0 kB

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Before/create.txt

1.9 kB

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.6 kB

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.1 kB

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Setup.txt

338 B

Exercise Files/6-oracle-plsql-transactions-dynamic-sql-debugging-m6-slides.pdf

158 kB