Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using decode function

728768Oct 29 2009 — edited Oct 30 2009
Hi

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details