Re: SQLplus syntax

From: Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de>
Date: 4 Aug 1999 13:15:26 GMT
Message-ID: <7o9ede$lv4$1@news.urz.uni-heidelberg.de>

Guillaume BRIALON <guillaume.brialon_at_synlog.com> 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.

With "set define ?" you can select "?" as new replacement character. See "help set" in sqlplus.

Johannes Received on Wed Aug 04 1999 - 08:15:26 CDT