Mega Code Archive
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>