RE: A How-To

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 23 May 2005 17:48:35 +0200
Message-Id: <20050523154838.C7CD18011027@smtp-out1.tiscali.nl>

From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl] Sent: Monday, May 23, 2005 17:46
To: 'BurtonL_at_frmaint.com'; 'oracle-l_at_freelists.org' 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Burton, Laura
Sent: Monday, May 23, 2005 17:25
To: oracle-l_at_freelists.org
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:

--

http://www.freelists.org/webpage/oracle-l Received on Mon May 23 2005 - 11:53:24 CDT