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

Thread: create proc

  1. #1
    Join Date
    Jan 2002

    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
    AZ, USA

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.