parameterized view
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: parameterized view

  1. #1
    Join Date
    May 2004
    Posts
    2

    parameterized view

    hi,

    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.

    thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Can you give an example of what you are trying to do?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2004
    Posts
    2
    i have to do a procedure which accepts a variable and depending on the variable given outputs a view. a friend of mine told me i have to call DDL

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sounds like the hard way to do whatever you are trying to do.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Oct 2002
    Posts
    807
    Am not sure what you're trying to do. Is this it?

    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')

    View created.

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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
    see attached file with procedure ...
    Attached Files Attached Files
    Last edited by davey23uk; 11-19-2007 at 11:18 AM.
    Best wishes!
    Dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width