Re: SQLplus syntax

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Wed, 04 Aug 1999 13:00:00 GMT
Message-ID: <37a83878.2594130@newshost.us.oracle.com>

On Wed, 04 Aug 1999 13:50:50 +0200, 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... '&' ?

In SQL*Plus, '&' is the default character used to prefix substitution variables. Thus, it thinks that you are specifying &Judie as a substitution variable.

In SQL*Plus or in your script, you can either set this to some other character via:

        SET DEFINE <some_other_character>

or simply turn variable substitution off with:

        SET DEFINE OFF
>
>Thx,
>Guillaume.
>

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Wed Aug 04 1999 - 08:00:00 CDT