ERPstuff - Oracle EBS Community

Posted: **Tue Jun 13, 2006 5:45 am**

Senerio: Table name GLTbl have 2 Column AmtDr and AmtCr
If Sum(AmtDr) > Sum(AmtCr) then
Sum(AmtDr) - Sum(AmtCr);
ElsIf Sum(AmtDr) < Sum(AmtCr)
Sum(AmtCr) - Sum(AmtDr);
Else
0;
End If;

Select Decode( Sign(Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0)), 1, Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0),-1, Nvl(Sum(AmtCr),0) - Nvl(Sum(AmtDr),0),0) Balnce
From GlTbl;

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

Posted: **Fri Jun 16, 2006 5:20 am**

Asalam-u-alikum
Rehan bahi It's Najm how are you i am on 20 days Leave now i am back i want to know where we use this type of query or also mention the condition/concept of this query it's very typical

Chears
Najm

Najm

Posted: **Fri Jun 16, 2006 5:22 am**

Ya better to have some output as well on the basis of sample data.thanks

ERPstuff - Oracle EBS Community

Make Condition in Decode Function (Tip)

Make Condition in Decode Function (Tip)