Mungkin fungsi ini adalah untuk penjumlahan mutasi debet kredit dalam akuntansi. misalnya mutasi debet untuk suatu buku besar akan menambah saldo buku besar tsb. Dan ketika mutasi kredit akan mengurani saldo. Mutasi debet biasa nya akan di lambangkan dengan "D" dan kredit dengan "K" atau "C". Begitu mungkin penjelasannya.. semoga membantu.. Ti Wawan Mulyawan Urang kuningan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Indra Armansyah Sent: Thursday, July 20, 2006 3:10 PM To: [email protected] Subject: Re: [indo-oracle] Fungsi sum dalam decode
Jika ACCOUNT_NO = 'D' maka hasilnya AMOUNT, jika ACCOUNT_NO <> 'D' maka hasilnya AMOUNT * -1 Misal: MYTABLE ACCCOUNT_NO AMOUNT ------------------ ------------- A 2000 B 4000 C 1000 D 1500 select SUM( DECODE(ACCOUNT_NO,'D', AMOUNT, AMOUNT * (-1))) from MYTABLE; Maka hasilnya -2000 + -4000 + -1000 + 1500 = -5500 Salam, Indra Armansyah [EMAIL PROTECTED] <mailto:indra%40hastinapura.com> com ----- Original Message ----- From: "aan" <[EMAIL PROTECTED] <mailto:aan%40pci.co.id> > To: <indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com> Sent: Thursday, July 20, 2006 2:48 PM Subject: [indo-oracle] Fungsi sum dalam decode > Dear All, > > Mohon Bantuannya ......! > > > > saya mendapatkan script di sebuah buku oracle yaitu fungsi sum di dalam > decode ..! > saya kesulitan mengartikan arti * (-1) dalam fungsi decode > > SUM( DECODE(ACCOUNT_NO,'D', AMOUNT, AMOUNT * (-1))) > > Tolong penjelasan dari script di atas > > Best Regards > Aan Angsori,SE > EDP Department > PT.Nikomas Gemilang > [EMAIL PROTECTED] <mailto:aan%40pci.co.id> > 0254 - 401586 Ext: 7192 > > > [Non-text portions of this message have been removed] > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: indo-oracle- <mailto:indo-oracle-unsubscribe%40yahoogroups.com> [EMAIL PROTECTED] > Website: http://indo- <http://indo-oracle.blogspot.com> oracle.blogspot.com > Mirror: http://indooracle. <http://indooracle.wordpress.com> wordpress.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo- <http://indo-thin.blogspot.com> thin.blogspot.com > Yahoo! Groups Links > > > > > > > > > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.10.2/393 - Release Date: 7/19/2006 > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
