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: sql query syntax

Re: sql query syntax

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Feb 2005 06:29:52 -0800
Message-ID: <1107268192.324041.151920@c13g2000cwb.googlegroups.com> 





What you want to do is join T1 and T2 on the ID column and then convert
the rows into columns.  Look up pivot tables in the archives.  The
analytic function row_number can also be useful in this task.
HTH -- Mark D Powell --
Received on Tue Feb 01 2005 - 08:29:52 CST












Original text of this message













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