Re: SQLplus syntax

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Fri, 06 Aug 1999 10:30:00 +0200
Message-ID: <37AA9D08.B6B2A48@informatik.uni-jena.de>

Hi,

in SQLplus you must do the following:

1. set escape on
2. you can insert as follow: insert into table values ('Jim \& Judie')

Hope this helps,

Regards, Jan

Guillaume BRIALON wrote:

> Hi,
> That's an hour I try to insert strings including a '&' character.
> e.g 'Jim & Judie'
> The problem is that for SQLplus, all that follows a '&' is a variable
> name!
> And then it asks me the value for Judie!
> How to escape this f... '&' ?
>
> Thx,
> Guillaume.

--

---

Jan Nowitzky o Friedrich-Schiller-Universität o Institut für Informatik o

D-07740 Jena o Tel. +49/3641/9-46363 o
E-Mail nowitzky_at_informatik.uni-jena.de | jan.nowitzky_at_sap-ag.de
---------------------------------------------------------------------------

Received on Fri Aug 06 1999 - 03:30:00 CDT