Inserting string data including &
From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Tue, 12 Aug 2008 13:58:55 -0400
Message-ID: <iij3a418r20pqinfo8sl9ce9rb4f8thv2c@4ax.com>
Date: Tue, 12 Aug 2008 13:58:55 -0400
Message-ID: <iij3a418r20pqinfo8sl9ce9rb4f8thv2c@4ax.com>
I'm trying to load a database table. The table contains several string
columns, and in many places the value of that string must contain an
ampersand (&).
When I code an insert statement like this:
insert into edit_messages (edit_number, title, intro) values(123, '-- line of error message', '-- line 2 of message);
SQL*Plus assumes that   is a variable and prompts me for a value for it. Is there a way to escape the & so that it becomes just part of the string?
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Tue Aug 12 2008 - 12:58:55 CDT
