We need to create a stored proc that contains '&' and '&&' as tockens. Is there any ways we can run it in SQL*Plus without gettting prompt for value replacement? Thanks.
Printable View
We need to create a stored proc that contains '&' and '&&' as tockens. Is there any ways we can run it in SQL*Plus without gettting prompt for value replacement? Thanks.
http://download.oracle.com/docs/cd/B...13.htm#1008884
SET DEF[INE] {&|c|ON|OFF}
Sets the character used to prefix substitution variables to c. ON or OFF controls whether SQL*Plus will scan commands for substitution variables and replace them with their values. ON changes the value of c back to the default '&', not the most recently used character. The setting of DEFINE to OFF overrides the setting of the SCAN variable. For more information on the SCAN variable, see the SET SCAN command.