Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do to insert '&' character from sqlplus ?
On Thu, 08 Jul 2004 08:12:26 -0700, jose luis fernandez diaz wrote:
> Hi,
>
> When I try to insert the '&' in a VARCHAR column I get a message from oracle.
>
> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.
set define ";"
set sqlterminator "&"
-- Well-behaved women seldom make historyReceived on Thu Jul 08 2004 - 18:29:38 CDT
![]() |
![]() |