Ohh begitu, kalo di oracle, kalo mau menjumlah memang harus menggunakan sum sih. tidak ada cara lain, tapi sebaiknya single query, dengan menggabungkan dua table inventori dan stock supaya data yg ingin ditampilkan terfilter berdasarkan data yg ada di table inventori dan stock tersebut.
Contoh: Select a.namabarang, sum(b.stock) qty, sum(b.stock)/100 persen_barang from inventory a, stock b Where a.kodebarang=b.kodebarang Semoga terpecahkan masalah nya mas feline Rgds, Shinta From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of felino Sent: Wednesday, November 19, 2008 12:58 PM To: [email protected] Subject: Re: [indo-oracle] PARSING PARAMETER DI ORACLE fungsinya sebagai variable , Jadi kalo ada query sbb SELECT NAMABARANG,@QTY_GDG:=(SELECT SUM(QTY) FROM STOCK) AS QTY,@QTY_GDG/100 AS PERSENBRG FROM INVENTORY kalo di oracle SELECT NAMABARANG,(SELECT SUM(QTY) FROM STOCK) AS QTY,(SELECT SUM(QTY) FROM STOCK)/100 AS PERSENBRG FROM INVENTORY jadi si mysql Tidak perlu menulis sum berkali2 salam Felino ----- Original Message ----- From: shinta anistasia To: [email protected] <mailto:indo-oracle%40yahoogroups.com> Sent: Wednesday, November 19, 2008 12:45 PM Subject: RE: [indo-oracle] PARSING PARAMETER DI ORACLE @ nya sendiri kalo di my sql berfungsi sebagai apa? Alias? Atau fungsi perhitungan , kalo yg dimaksud dengan alias, mending buat query nya seperti dibawah ini = @ yg dimaksud berubah menjadi 'as' select namabarang,harga,jumlah,harga*jumlah as ttl,total/10 as PPN from inventory semoga membantu Rgds Shinta From: [email protected] <mailto:indo-oracle%40yahoogroups.com> [mailto:[email protected] <mailto:indo-oracle%40yahoogroups.com> ] On Behalf Of felino Sent: Tuesday, November 18, 2008 3:31 PM To: [email protected] <mailto:indo-oracle%40yahoogroups.com> Subject: [indo-oracle] PARSING PARAMETER DI ORACLE Hello Teman - teman , numpang tanya dong, kalo di mysql perintahnya sbb : select namabarang,harga,jumlah,@total=harga*jumlah as ttl,@total/10 as PPN from inventory pengganti @ di oracle apa yah ? , mohon pencerahannya salam [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
