Hi,
Can anybody tell me when do we should use Define. I know Define is used with Char. I am looking for a example.
thankx in advance.
Printable View
Hi,
Can anybody tell me when do we should use Define. I know Define is used with Char. I am looking for a example.
thankx in advance.
Can you be more specific ? Do you mean DEFINE in SQL*Plus or something else ?
Hi akhil
The DEFINE command is used to load a CHAR variable with data.This can be used only with character data.If numeric data is loaded be sure to use appropriate conversion if it will be used for comparison purposes.
The EXAMPLE is
SQL>DEFINE POS=MANAGER
The above example assigns the text value "MANAGER" to the variable POS.If &POS is used in a script that follows,the value "MANAGER" will be substituted at runtime.