1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Use query stored in table / use output variable

Discussion in 'SQL PL/SQL' started by gitesh, Feb 9, 2010.

  1. gitesh

    gitesh Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    I want to use a query stored in a table (oracle 10g) thru plsql.

    table t1, column A varchar2(4000)

    Table contains a query for example "select * from t2"

    AND

    I want to use output variable in the same proceduer / another prodedure but don't know the code:confused:

    can any body help urgently.............................
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    @ Sadik , Please move the thred to PL/SQL section .

    I think you are looking for Dynamic SQL.
    Just have a look at the link. It will be a good start.
     
  3. gitesh

    gitesh Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi!

    Thanks for the reply.

    I have solved this problem last night. If insterested, can go thru
    'forums.oracle.com/forums/thread.jspa?threadID=1026870'
    'forums.oracle.com/forums/thread.jspa?threadID=1027500'