Oracle DEF

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>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s