| Lesson 3 | PL/SQL variables |
| Objective | Identify the different types of PL/SQL variables. |
Variables can be used to store the results of a query for later processing or to calculate values to insert into Oracle database
tables.
PL/SQL variables can be used anywhere in an expression, either in SQL or in PL/SQL statements.
PL/SQL variables can be used anywhere in an expression, either in SQL or in PL/SQL statements.
A variable must be declared before referencing it in other statements, including other declarative statements.
Use the following Slide Show to learn more about PL/SQL variables.
Procedure Language Sql
As you have seen, variables provide you with a medium for manipulating data.
In the next lesson, the different variable datatypes will be discussed.
As you have seen, variables provide you with a medium for manipulating data.
In the next lesson, the different variable datatypes will be discussed.
