Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> merge columns as rows in a result

merge columns as rows in a result

From: Ritesh G. <garodiar_at_yahoo.com>
Date: 19 Nov 2002 10:07:27 -0800
Message-ID: <1ada02e0.0211191007.4931724a@posting.google.com> 





hi,



I have a table like



FROM   QTY   TO




L1      2     L2
L2      4     L3
L1      5     L4





Now i want to conver this into 



L1   2


L2   -2


L2   4


L3   -4


L1    5


L4    -5



Can do this somehow with only a single SQL and no PL/SQL.



Thanks


Ritesh
Received on Tue Nov 19 2002 - 12:07:27 CST












Original text of this message













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