Re: Concatinate in a Query

You can do it even simpler in one literal string, such as :

select 'select name || '' '' || family from ASDF' from dual;

Anurag Varma wrote:

> You might be looking for something like this?
>
> select 'select name ||'||''' '''||'||family from ASDF' from dual;
>
> 'SELECTNAME||'||''''''||'||FAMILYFR
> -----------------------------------
> select name ||' '||family from ASDF
>
> .. if not .. then please specify the result you are looking for ...
>
> Anurag
>
> "Amin Emami" <amin_emami_at_yahoo.com> wrote in message
> news:6f13a27a.0207122133.1b72a0fc_at_posting.google.com...
> > hi list,
> >
> > I've got a question about concatination for Varchar2, in a query. I
> > want to do something like this below :
> >
> > update BlahBlah
> > set XQuery = 'select name || ' ' || family from ASDF'
> > where id =1 ^^^^^^^^^^
> >
> > you see, I want to seprate the name and family in my query with a
> > blank space, but it cause to terminate the update query.
> >
> > what can I do to solve my problem ? is there any special character for
> > blank space ?
> >
> > any suggestion is welcome
> > best wishes,
> >
> > Amin Emami