I'm trying to create a view that requires an input of variable instance on invocation, but am not succeeding. Can anyone give me a hand?? Maybe illustrate with an example... I'm pretty new to oracle and PL/SQL.
SQL> create view drop_me as (select * from dba_users where username='&1');
Enter value for 1: SYS
old 1: create view drop_me as (select * from dba_users where username='&1')
new 1: create view drop_me as (select * from dba_users where username='SYS')
SELECT * from TABLE(ttp4_1_results(7,22556));
SELECT * from TABLE(ttp4_1_results(7));
SELECT * from TABLE(ttp4_1_results);
Output:
Code:
TTP VERSION USERS TYPE PRIORITY PRODUCT PR STATUS
----- ----------------- ------------------------- --------------- ---------- ------------------------- -- ------------------
22742 Enhancement Medium Risque Front / Middle N Created Last Week
22743 VL3.2.7RC4 Benoit XXX Bug Medium Value N Created Last Week
22744 SC5.3.0.0 Yue XXX Bug Blocking RealTime Service N Created Last Week
22745 RQ5.1.5.8 Gregory XXX Enhancement Medium Risque Front / Middle N Created Last Week
22746 RQ5.1.5.8 Gregory XXX Enhancement High Risque Front / Middle N Created Last Week
22747 RQ5.1.5.7 Gregory XXX Bug High Risque Front / Middle N Created Last Week
22748 RQ6.0 Alpha Brian XXXX Enhancement High Risque Back Office N Created Last Week