Re: how to insert single quote by SQL in the table?
From: Ryan Pritchard <rpritcha_at_hcd.ca.gov>
Date: 13 Aug 2002 08:48:25 -0700
Message-ID: <7711a3c6.0208130748.561522ec_at_posting.google.com>
Date: 13 Aug 2002 08:48:25 -0700
Message-ID: <7711a3c6.0208130748.561522ec_at_posting.google.com>
You have to use an extra single quote to make Oracle continue to the next single quote, like so...
INSERT INTO PEOPLE_COMMENTS ( ID, COMMENT )
VALUES ( 123456789, 'DON''T WORRY' );
vismaymandloi_at_hotmail.com (vismay) wrote in message news:<2954112e.0208130102.65b0cb7f_at_posting.google.com>...
> Hi,
> i want to insert a string " don't worry" into my table but unable to
> do so as in sql string is terminated by single quotes (') . so please
> let me know how to do it?
Received on Tue Aug 13 2002 - 17:48:25 CEST