[Q] sqlplus: How to print '&'

From: kwatch <kwatch_at_lycos.jp>
Date: 31 Mar 2002 20:34:46 -0800
Message-ID: <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 Received on Mon Apr 01 2002 - 06:34:46 CEST