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

Hi there,

    Also try the following option:    

      run the following SET command at your sql prompt:

   show define

 this will give you the current substitution variable character which is &

then run
set define $
this will set $ as the substitution variable character which is only applicable for the current session and if you want the changes to be permanent then simply add the above set command in your login.sql( whcih is located in your Oracle directory). Use this varaible just like & in your queries e.g.,

select * from emp
where empno = $empno;

Hope this will answer your question

bye

Hassan Received on Wed Nov 07 2001 - 13:20:51 CET