Variables in PL/SQL

Variables in PL/SQL:
Use of variables
Variables can be used for
1) Temporary storage of data:

• Data can be temporarily stored in one or more variables for use when validating data Input for Processing the Data in the Data flow process.

2) Manipulation of stored values:

• Information is transmitted between PL/SQL and database with variables.
• Variables help in the data manipulation of stored values.
• Variables can be used for calculations and others data manipulations without accessing the database each and every time, Hence they help in reducing the I/O Cycles.

3) Reusability:

• Once declared can be used repeatedly by even in other blocks.

4) Ease of maintenance:

• Variables can be declared based on the declarations of the definitions of database columns.
• Provides Data Independence, reduces maintenance costs and allows programs to adapt the changes as the Database changes.