Oracle PL/SQL: Transactions, Dynamic SQL & Debugging
English | Size: 787 MB
Category: Video Training
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.
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.
Introduction6m 30s
Transaction Management in PL/SQL50m 9s
Autonomous Transactions27m 36s
Native Dynamic SQL58m 47s
Dynamic SQL Using DBMS_SQL1h 1m
Debugging PL/SQL Code37m 22s
Download Faster with Resume Support with Premium Account
RapidGator
http://rapidgator.net/file/a24e441e171212b8ae20f30d432eafdb/Oracle_PLSQL_Transactions.Dynamic_SQL.Debugging.part1.rar.html
http://rapidgator.net/file/a2d95439097fb8d46c696defa4caab4a/Oracle_PLSQL_Transactions.Dynamic_SQL.Debugging.part2.rar.html
Uploaded
http://uploaded.net/file/yqq2ssw5/Oracle%20PLSQL%20Transactions.Dynamic%20SQL.Debugging.part1.rar
http://uploaded.net/file/gp9eibjj/Oracle%20PLSQL%20Transactions.Dynamic%20SQL.Debugging.part2.rar
If any links die or problem unrar, send request to https://forms.gle/e557HbjJ5vatekDV9
Leave a Reply