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.
When the going gets tough, the tough gets going
Can you be more specific ? Do you mean DEFINE in SQL*Plus or something else ?
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
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.
Click Here to Expand Forum to Full Width