Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PLSQL_Declaring Variables
12-26-2010, 04:53 AM
Post: #1
PLSQL_Declaring Variables
After completing this lesson, you should be able to do the following:

List the benefits of PL/SQL
Recognize the basic PL/SQL block and its sections
Describe the significance of variables in PL/SQL
Declare PL/SQL variables
Execute a PL/SQL block

This chapter also explains in detail the following topics.

About PL/SQL
Benefits of PL/SQL
PL/SQL Block Structure
Block Types
Program Constructs
Use of Variables
Handling Variables in PL/SQL
Types of Variables
Declaring PL/SQL Variables
Naming Rules
Variable Initialization and Keywords
Base Scalar Datatypes
The %TYPE Attribute
Declaring Boolean Variables
Composite Datatypes
LOB Datatype Variables

please click the below link for the complete presentation
Declaring Variable

Oracle Certified Trainer
[Image: signature.php?uid=40]

User(s) browsing this thread: 1 Guest(s)