Insert a string with single quotation marks into a VARCHAR2 field
From: STS Oldenburg <akern_at_sts-systemtechnik.com>
Date: Tue, 24 Oct 2000 16:52:11 +0100
Message-ID: <8t47dh$3bj$01$1_at_news.t-online.com>
Date: Tue, 24 Oct 2000 16:52:11 +0100
Message-ID: <8t47dh$3bj$01$1_at_news.t-online.com>
[Quoted] [Quoted] I have in a table a field of type VARCHAR2, in which I'd like to insert a
[Quoted] value like " M_KEY='DTK' " (without the double quotations marks).
In the PL *PLUS Worksheet I've tried:
INSERT col1, col2
into table
[Quoted] values ('value1', ' M_KEY='DTK' ');
This doesn't work because of the single quotation marks.
What to do?
Thanks for a helpful hint. Received on Tue Oct 24 2000 - 17:52:11 CEST