Re: [Q] sqlplus: How to print '&'

[Quoted] "kwatch" <kwatch_at_lycos.jp> wrote in message news:cf674456.0203312034.460031c9_at_posting.google.com...
> Hi,
>
> I have a question.
> How do I print character '&' in sqlplus?
>
> SQL> select sysdate 'foo & bar' from dual;
> Enter value for bar:
> old 1: select sysdate 'foo & bar' from dual
> new 1: select sysdate 'foo ' from dual
> select sysdate 'foo ' from dual
> *
> ERROR at line 1:
> ORA-00923: FROM keyword not found where expected
>
>
> I tried "&", '\&', '&&', etc... but I didn't succeed.
> Please teach me the way if you know.
>
> Regards,
> Makoto

Try this:

SQL> set escape ^
SQL> select sysdate "foo &^ bar" from dual;

foo & bar