Re: WHERE clause with an & not meaning it to be a variable

Hi there

     Another option is that you can use the SET command to change the substitution variable (&) to any other character using the following commands:
  show define ( this will give you the current variable)

set define $ ( or you can use any other character) this will change the variable from & to $ for the current session or if you want the changes to be permenent then simply add the above line in your login.sql file which is located in your Oracle home directory.

Hope this answers your question.

bye

Hassan Ayub Received on Wed Nov 07 2001 - 13:15:25 CET