Re: Inserting "&" in SQL*Plus

set define off

or

set define (some other character)

then try ur load

HTH
Arvind

Matt Kelly wrote in message ...
>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 Thu Aug 12 1999 - 20:03:23 CDT