Re: character escapes

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 19 Aug 2004 06:30:22 +0200
Message-ID: <41242c61$0$28249$626a14ce@news.free.fr>

"steve" <a_at_b.com> a écrit dans le message de news:10i86edc0bs5708_at_corp.supernews.com...
> this is new to me...
>
> insert into some_table
> (
> some_column
> )
> values
> (
> 'ng&e'
> )
>
> the character & seems to be a special character for oracle. how do i
> properly escape it...and, are there any more characters that could foul an
> otherwise ansi compliant sql statement if they are not escaped?
>
> tia,
>
> steve
>
>

It's a default special character for SQL*Plus. Use: set define off or set scan off
and have a look at the SQL*Plus manual:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1011230

-- 
Regards
Michel Cadot

Received on Wed Aug 18 2004 - 23:30:22 CDT