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] 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:[EMAIL PROTECTED] On Behalf Of felino Sent: Tuesday, November 18, 2008 3:31 PM To: [email protected] 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]
