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 -> concatenating in a query

concatenating in a query

From: Adam The Cow <ezcow_at_softhome.net>
Date: 5 Jun 2001 09:44:57 -0700
Message-ID: <3a186582.0106050844.7db1d394@posting.google.com> 






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 - 11:44:57 CDT












Original text of this message













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