Re: Nested speech marks in sql insert

try
insert into db1 values(12, 15, 'insert into db2 values(1, 2,''Fred Bloggs'');'); That is two single quotes should equate to a single quote within a quoted string.

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
Received on Mon Feb 07 2000 - 20:00:09 CST