Using decode function
728768Oct 29 2009 — edited Oct 30 2009Hi
Help needed.... i need to create column as L, R in fact table in business layer using below mentioned logic
select count(decode (type, '41',1,'51',1,'61',1))L, count(decode(type, '71',1,'31',1,'81',1))R
Waiting for the reply soon.
thanks & regards
Edited by: user11933655 on 29-Oct-2009 10:26