Re: the '&'-sign

From: Kenneth Koenraadt <plovmand_at_>
Date: Sat, 18 Aug 2001 08:53:19 GMT
Message-ID: <3b7e2a78.3294719@news.mobilixnet.dk>

On Sat, 18 Aug 2001 00:55:40 +0200, "Rob" <rob_at_fcs.dhs.org> wrote:

>hi,
>probably a very stupid question but nevertheless...
>
>i'm trying to insert text into a table. sometimes a textline has the
>'&'-sign in it.
>you can guess: each insert with such a textline requires me to give in the
>value, but
>i want this &-sign to be seen as pure text.
>
>can someone tell me what the trick again is..?
>(i thought it was something with the use of slashes...)
>
>thanx in advance
>
>Rob
>
>

In Sql*plus :

SET SCAN OFF
or
SET DEFINE OFF Refer to the Oracle Online Documentation on SQL*Plus for further details.

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Sat Aug 18 2001 - 03:53:19 CDT