Re: Concatinate in a Query

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 13 Jul 2002 13:49:51 -0400
Message-ID: <JOZX8.6877$6r.360397@news4.srv.hcvlny.cv.net>

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
Received on Sat Jul 13 2002 - 12:49:51 CDT