Re: :block.varchar2item := 'need ' in here';
From: Charles Jardine <cj10_at_cam.ac.uk>
Date: Thu, 11 Mar 1999 17:06:12 +0000
Message-ID: <36E7F803.1CD17F48_at_cam.ac.uk>
Date: Thu, 11 Mar 1999 17:06:12 +0000
Message-ID: <36E7F803.1CD17F48_at_cam.ac.uk>
Gudrun Janssen wrote:
>
> Hello everybody,
>
> I think this is an easy one but even though I don't
> know and don't find in my documentation.
>
> How can I set varchar2-variables set to something
> with ' in without let the compiler notice it?
Double the ', as in:
my_var := 'The cat''s mother said ''Mew'''; Received on Thu Mar 11 1999 - 18:06:12 CET