DEFINE command with no arguments: list all variables defined : Define « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Define

DEFINE command with no arguments: list all variables defined

SQL>
SQL> -- DEFINE command and specifying no arguments: list all variables defined
SQL>
SQL> DEFINE V_STUDENT_NBR = "1000";
SQL>
SQL> DEFINE
DEFINE _DATE           = "10-SEP-06" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "XE" (CHAR)
DEFINE _USER           = "JAVA2S" (CHAR)
DEFINE _PRIVILEGE      = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR         = "Notepad" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" (CHAR)
DEFINE _O_RELEASE      = "1002000100" (CHAR)
DEFINE _RC             = "0" (CHAR)
DEFINE V_STUDENT_NBR   = "1000" (CHAR)
SQL>
SQL>
SQL>








Related examples in the same category

1.Define variable
2.The DEFINE command can be used to create substitution variables and assign them values