Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Ambersand in SQL/PLUS
dbriggs_at_dri.mgh.com wrote:
>
> There must be a simple solution to inserting fields
> with imbedded ampersand values without receiving a
> request for the parameter value. I just do not know
> what it is. Anyone ??
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
The & is the define character by default in SQL*PLus. Issue the command
set def XXX
where XXX is the character to use instead of the &.
Michael
+--------------------------------------------- + Michael Abbey Author of 5 works in the+ Ottawa Canada Oracle Press Series
+---------------------------------------------Received on Mon Sep 22 1997 - 00:00:00 CDT