SQL> CREATE TABLE Pivot_Table (Pivot_Col Number);
Table created.
SQL> CREATE OR REPLACE VIEW pivot_view AS
2 select 1 pivot_col from dual union
3 select 2 from dual union
4 select 3 from dual union
5 select 4 from dual union
6 select 5 from dual union
7 select 6 from dual union
8 select 7 from dual union
9 select 8 from dual union
10 select 9 from dual
11 /
View created.
SQL> SELECT rownum FROM pivot_view WHERE rownum <= 100;
ROWNUM
----------
1
2
3
4
5
6
7
8
9
9 rows selected.
semoga membantu,
ferry.
----- Original Message -----
From: "Yulius Wibowo" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, July 08, 2005 7:48 AM
Subject: [indo-oracle] Re: Generate angka
> 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/
