I think you mean
select 'select name '|| ' ' ||' family from ASDF' from dual;
Jim
"Martin Doherty" <martin.doherty_at_oracle.com> wrote in message
news:3D331277.D149BF6F_at_oracle.comX...
> 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
>
Received on Mon Jul 15 2002 - 21:55:18 CDT
