Re: Escape ampersand on insert

Try typing this in SQL*Plus before you do your insert:
set scan off;

...then type in your insert.
Hope that helps,
aaron

In article <7gl3ak$lrq$1_at_nnrp1.dejanews.com>,   yong321_at_yahoo.com wrote:
> At SQL*Plus, I can escape a character when I
select (use an escape clause).
> But what about insert? I want to insert a string
containing an ampersand.
> Thanks for help.
>
> Yong
> Email:yong321_at_yahoo.com
>
> -----------== Posted via Deja News, The
Discussion Network ==----------
> http://www.dejanews.com/ Search, Read,
Discuss, or Start Your Own
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 20:19:39 CDT