bisa juga coba google plsql table function / plsql pipe
2010/7/19 yulius_wibowo <[email protected]> > > > Perintah SELECT masuk dalam kategori SQL -> Non-procedural language, > sedangkan LOOP masuk dalam kategori procedural language (PL/SQL: Procedural > extension for SQL). > > Untuk dapat memasukkan LOOP ke dalam SQL (SELECT), harus dibuat fungsi > (PL/SQL function) terlebih dahulu, kemudian fungsi tersebut dipanggil dari > SQL. > > Salah satu contohnya adalah fungsi GREATEST tadi. > > Perintah SELECT sendiri pada dasarnya adalah spt perintah loop, > membaca data satu persatu dari dalam table. > Dan anda bisa memanggil SELECT dalam SELECT (SubQuery: pada FROM clause). > > > Bowo > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Agus > Vinus <vinu...@...> wrote: > > > > 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 <yulius_wib...@...> > > > To: [email protected] <indo-oracle%40yahoogroups.com> > > 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] <indo-oracle%40yahoogroups.com>, Agus > Vinus <vinus_9@> 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 <shgunawan@> > > > To: [email protected] <indo-oracle%40yahoogroups.com> > > > 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]<indo-oracle-unsubscribe%40yahoogroups.com> > > > 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] > > > > > -- thanks and regards ujang jaenudin jakarta - indonesia [Non-text portions of this message have been removed] ------------------------------------ -- -----------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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
