create proc
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: create proc

  1. #1
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195

    create proc

    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.

  2. #2
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width