Re: SQLplus syntax

Guillaume BRIALON <guillaume.brialon_at_synlog.com> wrote in message news:37A8291A.A42C5664_at_synlog.com...
> 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... '&' ?
>

1. SET DEFINE OFF
2. SET DEFINE (to another character) or
3. SET SCAN OFF