Re: how to convert row value to column
From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Sat, 05 Jan 2002 23:24:05 +0000
Message-ID: <3C378B13.E19C1079_at_exesolutions.com>
Date: Sat, 05 Jan 2002 23:24:05 +0000
Message-ID: <3C378B13.E19C1079_at_exesolutions.com>
You can do it using DECODE. For example:
SELECT DECODE(dummy, 'X', 1) ONE, DECODE(dummy, 'X', 2) TWO FROM dual;
Dan Morgan
saggi wrote:
> hi,
> can anybody help me
> to convert row value to column
> using sql or pl/sql.
> thanks in adv.
> bye
> saggi
Received on Sun Jan 06 2002 - 00:24:05 CET