Select tanggal,quantity,nvl(quantity,1)quantity_a from table a; -----Original Message----- From: Doni Hidayat [mailto:[EMAIL PROTECTED] Sent: Sunday, July 31, 2005 11:44 PM To: [email protected] Subject: [indo-oracle] Help query Tolongin dong, Saya punya data sebagai berikut, Table A: tanggal quantity ------------------- 1-1-05 1 2-1-05 3-1-05 4-1-05 4 5-1-05 6-1-05 7 7-1-05 9 8-1-05 9-1-05
Saya ingin kan data sebelumnya jika terisi null tanggal quantity quantity_A -------------------------------- 1-1-05 1 1 2-1-05 1 3-1-05 1 4-1-05 4 4 5-1-05 4 6-1-05 7 7 7-1-05 9 9 8-1-05 9 9-1-05 9 Ada yang bisa bantu querynya Thanks -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org <http://indo-oracle.lizt.org> (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com <http://indo-thin.vze.com> _____ YAHOO! GROUPS LINKS * Visit your group "indo-oracle <http://groups.yahoo.com/group/indo-oracle> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12ht3c72h/M=362335.6886445.7839731.1510227/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1122887174/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.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/
