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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting "&" in SQL*Plus

Re: Inserting "&" in SQL*Plus

From: Andrey Roslyakov <andrey-roslyakov_at_worldnet.att.net>
Date: Fri, 13 Aug 1999 01:09:38 -0400
Message-ID: <37B3A891.2ADE5B24@worldnet.att.net>


Try this : VALUES('a'||'''&'''||'b industries');

Andre.

Matt Kelly wrote:

> Question:
>
> INSERT INTO test_table (company_name) VALUES ('a & b industries');
>
> What can I use to ESCAPE the "&" in the example above?
>
> SQL*Plus keeps prompting me for the value of "b", but I only
> want to store the text string "a & b industries".
>
> Please email me if you know the answer!
>
> Thanks,
>
> --
> Matthew Kelly
> mkelly_at_clark.net
Received on Fri Aug 13 1999 - 00:09:38 CDT

Original text of this message

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