Re: string quote problem

From: <christianboivin1_at_my-deja.com>
Date: Wed, 27 Sep 2000 17:23:37 GMT
Message-ID: <8qtaec$7sl$1@nnrp1.deja.com>

you can do this

strsel := 'select * from sales where item = ''' || v_item || ''';'; put two quotes when you want one
in your string

Chris

In article <8qt484$22t$1_at_nnrp1.deja.com>, terry_stjean_at_my-deja.com wrote:
> I am building a string in PL/SQL.
> I want it to look as follows:
>
> select * from sales where item = '1000010';
>
> I have the following:
> strsel := 'select * from sales where item = ' || v_item || ';';
>
> v_item is a character variable used in the string.
> How do I get the single quotes around the value of v_item?
>
> Terry
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 12:23:37 CDT