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 -> Return Single Row with Multiple Cols Instead of Multiple Row

Return Single Row with Multiple Cols Instead of Multiple Row

From: Anil G <anil_at_pipelinesoftware.com>
Date: 25 Oct 2005 17:46:54 -0700
Message-ID: <1130287614.536409.198860@g47g2000cwa.googlegroups.com> 





Guys,



Is it possible to return single row with multiple columns instead of
multiple rows.



Basically, query returns following hierarchy.



product classification parent Classification

ABC        Motorcycle          Motorcycle
ABC        On Road             Motorcycle
ABC        Casual              On Road
ABC        Model               Casual





Hierarchy is not fixed level,and values of classification change based
on product.



Thank you in advance,



Anil G
Received on Tue Oct 25 2005 - 19:46:54 CDT












Original text of this message













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