view needed on the derived column [message #321083] |
Mon, 19 May 2008 00:41  |
dr.s.raghunathan
Messages: 540 Registered: February 2008
|
Senior Member |
|
|
Table Name : chk_SER
Tdate varchar2(16)
Ser_type varchar2(2)
ser_desc1 varchar2(30)
ser_amount number(14,2)
I want the view as
tdate varchar2(16)
cash number(14,2)
cheque number(14,2)
using the following querry
select tdate,decode(ser_desc1,'CASH',ser_amount,null) "cash",
decode(ser_desc1,'CHEQUE',ser_amount,null) "Cheque"
from chk_ser where ser_type='RV' order by tdate
is it possible
|
|
|
|
|