RE: A How-To

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 23 May 2005 17:48:35 +0200

From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx] 
Sent: Monday, May 23, 2005 17:46
To: 'BurtonL@xxxxxxxxxxx'; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: A How-To
Laura,

please provide some more info -- like a describe of the two tables involved?
also, showing headings above your query results below, and the queries
themselves, would help enormously :-)

kind regards,

Lex.
 
------------------------------------------------------------------
Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Burton, Laura
Sent: Monday, May 23, 2005 17:25
To: oracle-l@xxxxxxxxxxxxx
Subject: A How-To

I have a table which has multiple records for one individual.  Each record
represents a different field, i.e. id 31 represents start time, id 19 represents
shift, id 10 represents rate, etc.
 

What I want is to have each record to be listed as a column in a select
statement so that I have a line that shows the following:



--
//www.freelists.org/webpage/oracle-l

Other related posts: