Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Special characters in SQLPlus

Re: Special characters in SQLPlus

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 4 Oct 1999 11:55:21 GMT
Message-ID: <7ta4j9$2st$1@relay1.dsccc.com>


Try putting

        set scan off
at the top of the sql script.

Chris Forlano (cforlano_at_nortelnetworks.com) wrote:
: I'm using SQLPlus to submit values to a LONG that contain symbols
: like &, @, ; and I'm finding that SQLPlus is interpreting them as
: special characters.

: Is there an escape sequence I can use (like \ or ') to get them
: accepting in my string?

: Thanks,

: Chris

: --
: Chris Forlano
: Automation Development
: Nortel Networks, Maidenhead
: 590 4342 (01628 434 342)
: cforlano_at_nortelnetworks.com

--
While Alcatel may claim ownership of all my ideas (on or off the job), Alcatel does not claim any responsibility for them. Warranty expired when u opened this article and I will not be responsible for its contents or use. Received on Mon Oct 04 1999 - 06:55:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US