Re: Doing concatenation in SELECT

Add an additonal ' to get the single quote to appear. As an example,

      select 'user''s' from dual;

displays

      user's

Peggy Lok wrote:
>
> I understand that we can generate string concatenation in SELECT
> with the use of || and '
>
> (e.g. select 'user sid is ' || sid from v$session;)
>
> However, what if I want to put a single-quote (ie ' ) in the generated
> statement, how can I tell Oracle to take the quote (') as it is??
>
> Please advise, thanks.
>
> Peggy
 

-- 
Frank Hubeny            
fhubeny_at_ntsource.com            
Wheaton, IL 60187