Re: Insert a string with single quotation marks into a VARCHAR2 field
From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: Wed, 25 Oct 2000 08:35:10 -0600
Message-ID: <biCJ5.44$r%2.8782_at_wdc-read-01.qwest.net>
Date: Wed, 25 Oct 2000 08:35:10 -0600
Message-ID: <biCJ5.44$r%2.8782_at_wdc-read-01.qwest.net>
Double-up your single quotes.
> values ('value1', ' M_KEY=''DTK'' ');
That's 2 single-quotes together (''), not 1 double-quote (").
"STS Oldenburg" <akern_at_sts-systemtechnik.com> wrote in message
news:8t47dh$3bj$01$1_at_news.t-online.com...
> I have in a table a field of type VARCHAR2, in which I'd like to insert a
> value like " M_KEY='DTK' " (without the double quotations marks).
> In the PL *PLUS Worksheet I've tried:
> INSERT col1, col2
> into table
> 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 Wed Oct 25 2000 - 16:35:10 CEST