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!

query optimization

Discussion in 'SQL PL/SQL' started by swathi, Mar 19, 2009.

  1. swathi

    swathi Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    how to execute multiple queries in a single query statement
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    could you explain more what you are trying to do. Multiple queries can be executed in many ways. if you don't explain your problem how can someone post a solution?
     
  3. tyro

    tyro Forum Genius

    Messages:
    368
    Likes Received:
    20
    Trophy Points:
    260
    Location:
    India
    hmmm if you mean a dynamic query you have to use a pl/sql code block and store your queries in a string and use execute immediate on that string