Define variable : Define « PL SQL « Oracle PL / SQL






Define variable


SQL>
SQL> -- examine the contents of a variable created using the DEFINE command by typing DEFINE
SQL> -- and specifying the variable name:
SQL>
SQL> DEFINE V_STUDENT_NBR = "1000";
SQL>
SQL> DEFINE v_student_nbr;
DEFINE V_STUDENT_NBR   = "1000" (CHAR)
SQL>
SQL> DEFINE V_STUDENT_NBR   = "1000" (CHAR);
SQL>
SQL>
           
       








Related examples in the same category

1.DEFINE command with no arguments: list all variables defined
2.The DEFINE command can be used to create substitution variables and assign them values