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 -> Combining fields

Combining fields

From: Scott <me_at_yahoo.com>
Date: Fri, 30 Mar 2001 21:00:35 GMT
Message-ID: <3ac4f3f0.24256388@news.mn.uswest.net> 






I am trying to combine 3 fields in a Oracle 7 view.  ITEMNO is text,
PROD_DATE is a date and SHIFT is a number.  In access I would do
somethine like below:



HIST_ILLUM_PART.ITEMNO+Str(PDAYPROD.PROD_DATE)+Str(PDAYPROD.SHIFT)+AS
Key



It would return something like:



ZYZ 03/30/01 2


How do I accomplish this in Oracle?



Thank You in Advance!!!


Scott
Received on Fri Mar 30 2001 - 15:00:35 CST












Original text of this message













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