tailieunhanh - BASICS OF PROCEDURE BUILDER

A key feature of procedural programming is the ability to create and debug code quickly and easily. Procedure Builder provides all of the functionality necessary for you to successfully develop and debug PL/SQL programs. This lesson enables you to manipulate PL/SQL code using Procedure Builder. At the end of this lesson, you should be able to Identify the advantages of developing and debugging PL/SQL programs in Procedure Builder. Manage program units by using the Object Navigator. Execute program units and SQL statements by using the PL/SQL Interpreter. Define and compile procedures by using the Program Unit editor. Define and compile database procedures by using the. | 19 Basics of Procedure Builder ORACLG Objectives Identify advantages of developing and debugging PL SQL programs in Procedure Builder. Use different windows in Procedure Builder to complete tasks including Object Navigator PL SQL Interpreter Program Unit Editor and Stored Program Unit Editor. Control execution of an interrupted PUSQL program unit. Test possible solutions at runtime. Timing Schedule 60 minutes 15 minutes 75 minutes Topic Lecture Practice Total Class Management Note If using SQL Plus instead of Procedure Builder replace this lesson with Appendix C. Files required for this lesson Demonstration Practice 19-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives A key feature of procedural programming is the ability to create and debug code quickly and easily. Procedure Builder provides all of the functionality necessary for you to successfully develop and debug PL SQL programs. This lesson enables you to manipulate PL SQL code using Procedure Builder. At the end of this lesson you should be able to Identify the advantages of developing and debugging PL SQL programs in Procedure Builder. Manage program units by using the Object Navigator. Execute program units and SQL statements by using the PL SQL Interpreter. Define and compile procedures by using the Program Unit editor. Define and compile database procedures by using the Stored Program Unit editor. Set a breakpoint to suspend program execution. Control the execution of an interrupted PL SQL program unit. Test possible solutions by changing variables and procedures at runtime. Basics of Procedure Builder .