Dear Rendy, Wah klo itu SELECT dalam LOOP Pak, bukan sebaliknya.
Salam. ________________________________ From: Rendy Rendy <[email protected]> To: [email protected] Sent: Monday, July 19, 2010 16:50:58 Subject: Re: [indo-oracle] Re: Loop dalam SELECT Bisa bro, For i in ( select statement ) loop statement end loop; end; Regards, --- On Mon, 7/19/10, Agus Vinus <[email protected]> wrote: From: Agus Vinus <[email protected]> Subject: Re: [indo-oracle] Re: Loop dalam SELECT To: [email protected] Date: Monday, July 19, 2010, 2:06 AM Dear Pak Yulius Wibowo Iya Pak udah saya coba ternyata bisa, terima kasih bantuannya. Tapi sebenernya bisa ga LOOP didalam SELECT?? (masih penasaran) Salam, Agus V. ________________________________ From: yulius_wibowo <[email protected]> To: [email protected] Sent: Monday, July 19, 2010 11:12:57 Subject: [indo-oracle] Re: Loop dalam SELECT Coba pakai fungsi GREATEST SQL> SELECT GREATEST(tanggal1, tanggal2, tanggal3, tanggal4, tanggal5) FROM table; bowo --- In [email protected], Agus Vinus <vinu...@...> wrote: > > Dear P. Henry > > Terima kasih untuk tanggapan P. Henry > Sebab saya mau membandingkan beberapa kolom tanggal dan akan saya ambil yang > terbesar contoh: > SELECT tanggal1, tanggal2, tanggal3, tanggal4, tanggal5 > FROM table > > bagaimana kira2 saya bisa mengambil kolom yang nilainya tertinggi?? > mohon pencerahan?? > > Salam, > Agus V. > > > > > ________________________________ > From: Henry <shguna...@...> > To: [email protected] > Sent: Sunday, July 18, 2010 3:11:29 > Subject: Re: [indo-oracle] Loop dalam SELECT > > Kenapa harus pakai Loop. > dan kira2 mau ngapain nich? > > Ibaratnya ada cara cepet kenapa mikirin cara lama. > > thanks > > Agus Vinus wrote: > > > > Dear Suhu, > > > > Maaf saya masih newbie mo tanya, apa bisa sintak LOOP dimasukkan > > didalam SELECT > > seperti WHEN CASE, klo bisa kira2 bagaimana cara penulisannya?? > > > > Salam, > > Agus V. > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > No virus found in this incoming message. > > Checked by AVG - www.avg.com > > Version: 9.0.839 / Virus Database: 271.1.1/3009 - Release Date: 07/16/10 > >02:35:00 > > > > > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > [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]
