Home -> Usenet -> comp.databases.oracle -> Q: how to insert text which includes a & (ampersand) using sqlplus

Q: how to insert text which includes a & (ampersand) using sqlplus

From: Doron Sherman <dorons_at_w3spider.com>
Date: 1996/07/08
Message-ID: <31E137FC.6134_at_w3spider.com>#1/1 







I hope someone knows the answer to this question:



In sqlplus, using an INSERT statement like the following -



INSERT INTO table1 VALUES ('A & B')



causes a prompt to appear as a response for asking a value
for B, rather than inserting the string 'A & B' into the database.



My question is, how is a & (ampersand) inserted using an INSERT
statement. Is there a special escaping needed for that ?



Thanks in advance,



Doron\



Please respond by email to: dorons_at_w3spider.com
Received on Mon Jul 08 1996 - 00:00:00 CEST












Original text of this message