Re: Inserting "&" in SQL*Plus

& is the default character for define envionment option in SQL PLUS. Try after swiching it off. you can do that from options-->enviornment in SQL plus.

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

--

Ramesh Subbyian                             Work    : 650-413-1217
http://www.inventa.com                    Pager    : 888-709-3153