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))
>
>
>
mhm... dari wizard kok jalan yah.. *aneh*
Benaran tadi gua coba bikin manual, selalu error. akhirnya gua jadiin
view (sesuai petunjuk link dibawah).
dan menurut
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2270447621346
,
emang gak bisa.
</quote>
Hi, Tom,
Greate solution, but chanllenge is: it it possible we build query based
on SQL
type in the ORACLE report/form?
Somthing like: ---- query in report
select *
from t1
where pk_col in (select * from TABLE(cast(PL_sql_tb as
some_sql_type)));
it seems problem to me when i try it, please also clarify
if it is OK in ORACLE form?
Thanks
Followup:
Either
o use dynamic sql
o hide the construct in a view and select * from the view
that is what I do if a particular tool won't accept some fancy SQL
construct.
</end of quote>
Any comment ??
--
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/
