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/
