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

Home -> Community -> Usenet -> c.d.o.misc -> Looking for a Sql statement

Looking for a Sql statement

From: <thomasla5440_at_my-dejanews.com>
Date: Thu, 14 Jan 1999 18:03:47 GMT
Message-ID: <77lbhs$c5m$1@nnrp1.dejanews.com> 





Looking for a sql statement which will take column 1 and column 2 from table A
and make column 1 the header and column 2 the 1 row of data.


example:  LAB          RESULT
          hemoglobin     10
          wbc            20
          heart rate     70
          height         165





etc, ...


and you want a report -

hemoglobin     wbc  heart rate     height     etc, ...
10             20   70             165

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    


Received on Thu Jan 14 1999 - 12:03:47 CST












Original text of this message













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