PLSQL Variables

Описание: Variable in pl/sql in Oracle 10g basics

syntax
var name datatype(size);

only one variable can be declared in a single line

How to Initialize the variables
1.
:=(assignment operator)
a number(2):=10;

a:=10;
Note : you can initialize variable at declare time as well as run time.

2. if we want to take values at run time

a number(2):=&a;
(this can be done at the declare time otherwise you can only declare a variable and initialize it in begin section.)
for further queries you can write to me on

[email protected]

or you can see more interesting videos on

https://www.anandharsha.wordpress.com

The variable naming convention as suggest in the video's link is given here


   • Variables in C Language Part-2  

Thanks you
all the best
Anand Harsha.