Saya sudah coba pakai parameter ... sip tuh ... [menggunakan : select * from TABLE(gen_numbers(¶m1)) ]
Bowo --- In [email protected], Herman <[EMAIL PROTECTED]> wrote: > > Herman wrote: > > >Yulius Wibowo wrote: > > > > > > > >>4. Create Report using Report Builder (Wizard) > >>Source type : SQL Query > >>Data Source : select * from TABLE(gen_numbers(3)) > >>dst...dst ... > >> > >>Agar lebih dinamis, nilai "3" di sini, bisa diganti dengan parameter > >> > >>select * from TABLE(gen_numbers(:param1)) > >>OR > >>select * from TABLE(gen_numbers(¶m1)) > >> > >> > >> > >> > >> > Format query yang pertama jalan, query dengan parameter gak > jalan.(ora-22905) > Yang saya coba manual adalah query dengan parameter. > > -- > Herman > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
