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