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 -> Re: Looking for a Sql statement

Re: Looking for a Sql statement

From: Claire M. <cmarcoux_at_webnet.qc.ca>
Date: Thu, 14 Jan 1999 19:46:40 GMT
Message-ID: <01be3ff7$2104fe80$113a0dd8@clairema>


Hi! Thomas
Just write

Do it with REPORT,
Select your table A
Then put Your layout style to master detail

                         data selection to across/down
And RUN.
It will be the way you want.

In your data model ,
Your select is just
SELECT column1, column2
FROM table;
Good Luck.
Claire M.

thomasla5440_at_my-dejanews.com a écrit dans l'article <77lbhs$c5m$1_at_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 - 13:46:40 CST

Original text of this message

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