Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: concatenating in a query

Re: concatenating in a query

From: TurkBear <noone_at_nowhere.com>
Date: Tue, 05 Jun 2001 12:00:34 -0500
Message-ID: <1v3qht0rs8b66mhjkjklh2h2vq0jlohus7@4ax.com>

It should work in the query:
Here's one I ran :



  select dept_nbr||zip_cd||last_update||','||union_cd part1,empl_nbr   from hr_public where rownum < 10;
PART1                             EMPL_NBR
--------------------------------- -----------
T797315   55422     05-JUN-01,MMA 00063763
T799675   55901-584805-JUN-01,GEC 00050731
T794170   55107     05-JUN-01,GEC 00048905
T799681   55901-584805-JUN-01,GEC 00042670
T796240   55155-189905-JUN-01,MAP 00036632
T797412   55422     05-JUN-01,AFS 01028200
T799162   55792     05-JUN-01,AFS 01028253
T796545   55109     05-JUN-01,AFS 01028064
T792309 55155-189905-JUN-01,MAP 01027811 9 rows selected.

SQL>


ezcow_at_softhome.net (Adam The Cow) 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.
Received on Tue Jun 05 2001 - 12:00:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US