Re: On insert, what characters do I need to escape? (or do I?)

From: <shiling_at_math.wayne.edu>
Date: Sun, 23 May 1999 02:21:57 GMT
Message-ID: <7i7oo4$fg6$1@nnrp1.deja.com>

You may do:
set scan off

example,
SQL> set scan off
SQL> run
1 insert into mysales
2* values (999,'as & l',5,'8-jan-99')

1 row created.

In article <3747c63e.22299022_at_news.pacbell.net>, brian_at_brie.com (Brian Lavender) in part wrote:
>
> I am still getting errors on my inserts when I try an ampersand.
>
> insert into foo values (35.3,'tommy',null,'string & ampersand');
> ^ escape this?
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Sat May 22 1999 - 21:21:57 CDT