In this lesson, you create a simple PL/SQL block after learning the various elements that compose a block. At the end of this lesson, you should be able to Declare and use variables and constants in PL/SQL. Assign new values to variables within the executable section. Create and execute a named PL/SQL subprogram in Procedure Builder. | 21 Developing a Simple PL SQL Block ORACLG Objectives Declare and use variables and constants in PUSQL. Assign new values to variables within the executable section. Create and run PLVSQL subprograms in Procedure Builder. 21-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives In this lesson you create a simple PL SQL block after learning the various elements that compose a block. At the end of this lesson you should be able to Declare and use variables and constants in PL SQL. Assign new values to variables within the executable section. Create and execute a named PL SQL subprogram in Procedure Builder. Developing a Simple PL SQL Block .
