Re: PL/SQL apostrophes

<joycox_at_my-deja.com> wrote in message news:7m3lur$toh$1_at_nnrp1.deja.com...

> I want to be able to print out apostrophes onto my html pages (using
> htp.p) but everytime I use one, pl/sql thinks that it is the end of the
> quote. How can I get around this?

Just think of it like this; every time you want to print out an apostrophe, type two.

1. print('This is a string with an '' in it!');
2. text = 'select * from table where field1=''' || value || ''';
3. print('''');

I guess.

Rune Received on Fri Jul 09 1999 - 02:23:47 CDT