Re: Inserting "&" in SQL*Plus

From: Clifton Wood <cbwood_at_vt.edu>
Date: Thu, 12 Aug 1999 18:53:05 -0400
Message-ID: <37B35051.F0D126F4@vt.edu>

You can always load it using SVRMGRL

>> svrmgrl user/passwd @/path/to/script.sql

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

--

---

Clifton B. Wood
Programmer/Analyst for the Entomology Dept. of Va. Tech.

------------------ Thought of the Decade -------------------

windows98 = n. 64 patches to 32 bit extensions and a graphical shell for a 16 bit patch to an 8 bit operating system originally coded for a 4 bit microprocessor, written by a 2 bit company that can't stand 1 bit of competition. Received on Thu Aug 12 1999 - 17:53:05 CDT