Re: concatenating in a query

A copy of this was sent to ezcow_at_softhome.net (Adam The Cow) (if that email address didn't require changing) On 5 Jun 2001 09:44:57 -0700, you wrote:

>I can't get this concatination to work and I was wondering if anyone
>else knows why.
>
>G.street_num||' '||G.street_name||' '||G.city||', '||G.state||'
>'||G.zip
>
>it is being used in a query search with other statments. I thought
>that you could concatenate constants like this.
>
>This however works:
>G.street_num||G.street_name||G.city||G.state||G.zip
>does anyone know how I can get the above delimiters to work
>
>Thanks
>Cheers
>Adam dR.

how about a cut and paste of the REAL query with the error message from sqlplus?

that definitely does work:

scott_at_TKYTE816> select ename || ' ' || mgr || ' ' || deptno || ', ' || sal || '   2 ' || hiredate
  3 from emp;

ENAME||''||MGR||''||DEPTNO||','||SAL||''||HIREDATE

SMITH 7902 20, 800
17-DEC-80 ALLEN 7698 30, 1600
20-FEB-81 WARD 7698 30, 1250
22-FEB-81
.....

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp