Xref: alice comp.databases.oracle.misc:52364 From: johng@mm.com (TurkBear) Newsgroups: comp.databases.oracle.misc Subject: Re: Nested speech marks in sql insert Date: Wed, 02 Feb 2000 18:06:25 GMT Reply-To: See Message body for real address Message-ID: <389a6f83.163117580@204.181.81.99> References: <1140b6b8.76f791f5@usw-ex0109-066.remarq.com> X-Newsreader: Forte Agent 1.5/32.451 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: 2 Feb 2000 11:59:58 -0600, 156.98.4.11 Lines: 52 X-Authenticated-User: turkbear X-Report: Report abuse to abuse@newsfeeds.com X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body X-Abuse-Info2: ALL Spam complaints are acted upon within 24 hours! Organization: Newsfeeds.com http://www.newsfeeds.com 60,000+ UNCENSORED Newsgroups. Path: alice!news-feed.fnsi.net!feed.newsfeeds.com!newsfeeds.com!goliath.newsfeeds.com!newsfeeds.com!156.98.4.11 Use " for the string inside the ' so: insert into db1 values(12, 15, 'insert into db2 values(1,2,'insert into db2 values (1,2,"Fred Bloggs");'); Like this: ---------------------------------------------------------- SQL> create table test_insert( 2 f1 number, 3 f2 number, 4 f3 varchar2(50)); Table created. SQL> insert into test_insert values(1,2,'insert into db2 values(1,2,"Fred Boggs");'); 1 row created. SQL> select * from test_insert 2 ; F1 F2 F3 --------- --------- -------------------------------------------------- 1 2 insert into db2 values(1,2,"Fred Boggs"); --------------------------------------------------------------------------------------------------------------- Hope it helps... kevin wrote: >I have an oracle database >i am inserting SQL statements into it. >I have a line > >insert into db1 values(12, 15, 'insert into db2 values(1, >2,'Fred Bloggs');'); > >any ascii value equivalent that will work >for nested ' > >thankyou > > >* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----