PIPELINED Function, gunanya untuk menghasilkan records/rows dari function. Function yg biasa hanya menghasilkan nilai scalar (satu nilai at one time).
Penggunaan dilapangan, misalnya untuk PIVOTING table. Atau contoh yg ada ini untuk menghasilkan nilai (berupa records, tanpa harus mengakses ke table, all in memory, no disk read) Any idea CMIIW, Bowo --- In [email protected], gua banget <[EMAIL PROTECTED]> wrote: > hi, > > tanya dong script kayak ginian buat apaan ya kalo dalam real lifenya > > thx > > On 7/8/05, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > Mungkin bisa dicoba pakai fungsi .... > > > > Contoh sbb: > > > > SQL> CREATE OR REPLACE TYPE my_type AS OBJECT (nomor NUMBER); > > 2 / > > > > Type created. > > > > SQL> CREATE OR REPLACE TYPE my_type_tbl AS TABLE OF my_type; > > 2 / > > > > Type created. > > > > SQL> CREATE OR REPLACE FUNCTION gen_angka(p_max NUMBER) > > RETURN my_type_tbl PIPELINED > > IS > > TYPE ref1 IS REF CURSOR; > > out_rec my_type := my_type (NULL); > > BEGIN > > FOR i IN 1..p_max LOOP > > out_rec := my_type(i); > > PIPE ROW(out_rec); > > END LOOP; > > END; > > / > > > > SQL> select * from table(gen_angka(4)); > > > > NOMOR > > ---------- > > 1 > > 2 > > 3 > > 4 > > > > SQL> select * from table(gen_angka(10)); > > > > NOMOR > > ---------- > > 1 > > 2 > > 3 > > 4 > > 5 > > 6 > > 7 > > 8 > > 9 > > 10 > > > > > > Bowo > > > > > > > > > > > > > > --- In [email protected], Herman <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > > > > Ada yang tahu cara mengenerate angka dengan grant user biasa? > > > > > > Contoh yang working dengan user dba : > > > > > > select rownum > > > from user_objects > > > where rownum <= 10 > > > > > > angka 10 itu hanya contoh. Kita bisa merubah sesuka hati kita. > > > Dengan user biasa, contoh diatas tidak bisa berjalan dengan baik > > karena > > > user_objectsnya terbatas. > > > > > > Thanks before. > > > > > > Herman > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.blogspot.com > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- 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/
