Use VARIABLE command to define variable : Variable « PL SQL « Oracle PL / SQL






Use VARIABLE command to define variable


SQL>
SQL> -- Typing the VARIABLE command with no arguments provides a list of all 
variables created with the
SQL> -- variable command:
SQL>
SQL> VARIABLE my_student NUMBER;
SQL>
SQL> VARIABLE
variable   my_student
datatype   NUMBER
SQL>
           
       








Related examples in the same category

1.Variable command: define a variable
2.Define variable and use it in SQL statement in PL/SQL
3.Use block name to reference a variable name