Debugging Oracle PL/SQL with SQL Developer
| Author | : | |
| Rating | : | 4.29 (668 Votes) |
| Asin | : | B00BPWU8RM |
| Format Type | : | |
| Number of Pages | : | 213 Pages |
| Publish Date | : | 2017-04-14 |
| Language | : | English |
DESCRIPTION:
Five Stars Andrzej Pyka The book is very short, but will quickly teach you how to use the debugging facility in SQL Developer.
In this tutorial we will explain how to debug Oracle (11.2) PL/SQL code with Oracle’s SQL Developer (3.2) tool. Sample code for debugging1.4 Database Administrator PrivilegesChapter 2 – Debugging a PL/SQL procedure2.1 The debug ribbon2.2 Compiling in debug mode2.3 Creating a breakpoint2.4 The Debug Execution Ribbon2.5 Inspecting a variable2.6 Stepping through code2.7 Setting a variable watch2.8 Depositing a value into a variable2.9 Debug WindowsChapter 3 –Debugging Triggers3.1 Trigger design3.2 Trigger example code3.3 How to debug a triggerChapter 4 – Performance problems in PL/SQL4.1 Tagging SQL statements4.2 Profiling PL/SQL code4.3 Performance in summaryChapter 5 –Various items5.1 PL/SQL Meta DataChapter 6 – In conclusion6.1 Benefits of SQL Developer Debug6.2 Disadvantages of SQL Developer DebugBonus Material related to this eBookMore titles from Richard Thrust. Read it now and get the knowledge you need to succeed!Table of Contents from the bookIntroductionEnvironment configurationChapter 1 – The environment1.1 Download and install Oracle XE1.2 Download and install SQL Developer1.3 DBA tasks to set up the database1.3. We will cover how to:1.Compile a PL/SQL module in debug mode,2.Set a breakpoint in a module so the code execution stops at a specified point,3.Set a watch on a variable