Re: PL/SQL apostrophes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 11 Jul 1999 20:35:06 +0800
Message-ID: <37888F7A.4AD0@yahoo.com>

joycox_at_my-deja.com wrote:
>
> 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?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

x:= 'O''Brien';

or for neatness...

declare
  quote varchar2(1) := '''';
begin
  string := quote || 'some quoted text' || quote; end;

HTH --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jul 11 1999 - 07:35:06 CDT