Re: Inserting "&" in SQL*Plus

From: Vladik <reason_at_shadow.net>
Date: Wed, 18 Aug 1999 20:31:33 -0400
Message-ID: <rrn2onerboh90@corp.supernews.com>

In SQL plus,
before executing your sqls,
type:

set define off;

Regards,
Vladislav

Matt Kelly <mkelly_at_shell.clark.net> wrote in message news:i_Gs3.314$BI1.16839_at_iad-read.news.verio.net...
> 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 Wed Aug 18 1999 - 19:31:33 CDT