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 -> Crosstab SQL Query

Crosstab SQL Query

From: John Pimentel <jpimentel_at_freebalance.com>
Date: Thu, 06 Aug 1998 05:01:16 GMT
Message-ID: <35C9384C.F26D9BAA@freebalance.com>


Can anyone tell me of an easy way to obtail cross-tab results from a SQL query?
For example:

   select a, b, c, d
   from table (with 3 rows)
Required results:
 col row1 row2 row3



  a row1 row2 row3
  b row1 row2 row3
  c row1 row2 row3
  d row1 row2 row3 Received on Thu Aug 06 1998 - 00:01:16 CDT

Original text of this message

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