OK. Jadi begini, untuk mendapatkan data menggunakan SELECT statement, umumnya kita menggunakan TABLE atau VIEW pada FROM clause-nya, contoh: SELECT * FROM table_name; SELECT * FROM view_name;
Selain table & view kita juga dapat menggunakan fungsi sebagai ROW SOURCE-nya. Dengan syarat, fungsinya HARUS mengembalikan record-set. Nah, agar sebuah fungsi dapat mengembalikan record-set, definisi dari fungsinya menggunakan PIPELINED. Begitu Mas, .... :-) Nah contohnya sbb: SQL> CREATE TYPE my_array IS TABLE OF NUMBER; / SQL> CREATE OR REPLACE FUNCTION get_date(p_month DATE) RETURN MY_ARRAY PIPELINED IS start_date NUMBER := TO_NUMBER(TO_CHAR(trunc (p_month,'MONTH'),'DD')); end_date NUMBER := TO_NUMBER(TO_CHAR(last_day(p_month),'DD')); BEGIN FOR i IN start_date..end_date LOOP PIPE ROW(i); END LOOP; RETURN; END; / SQL> SELECT * FROM TABLE(get_date(SYSDATE)); SQL> SELECT TRUNC(SYSDATE,'MONTH') + COLUMN_VALUE - 1 FROM TABLE(get_date(SYSDATE)); Note: Anda bisa memasukkan data tanggal dengan type DATE sebagai ganti SYSDATE. CMIIW, Bowo --- In [email protected], Kang Oyib <[EMAIL PROTECTED]> wrote: > > Maaf nih mas bowo, saya masih awam dlm oracle, > PIPELINED FUNCTION aja saya belum tau nih..... > > saya baru belajar, dan saya mendapat kesulitan saat select tanggal dlm 1 > bulan. misal november tanggal 1 sampai 30. > 01112005 > 02112005 > - > - > - > 30112005 > > > On 12/15/05, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > > Coba buka kembali arsip mengenai pengguanaan PIPELINED FUNCTION > > > > Bowo > > > > --- In [email protected], Kang Oyib <[EMAIL PROTECTED]> wrote: > > > > > > Dear's Oracle Mania.... > > > > > > Saya mau tanya, bagaimana caranya select semua tanggal pada suatu > > bulan..? > > > > > > thank's atas solusinya > > > > > > > > > Regard's > > > > > > Oyib > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------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/
