
A help post. See the information being provided by DEF command! You can also see some variables I have declared. (userid, myname etc)
SQL> def
DEFINE _DATE = "04-JAN-08" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "cbolmis" (CHAR)
DEFINE _USER = "SYSTEM" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE = "1002000100" (CHAR)
DEFINE C_NAME = "pandian" (CHAR)
DEFINE CNAME = "pandian" (CHAR)
DEFINE MYA = "pandian" (CHAR)
DEFINE USERID = "102" (CHAR)
DEFINE MYUNAME = "richard" (CHAR)
DEFINE MYUNAME2 = "richard" (CHAR)
SQL>