parsing of a query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: parsing of a query

  1. #1
    Join Date
    Feb 2006
    Posts
    86

    parsing of a query

    Hi

    i am writting this query :
    " select * from emp where ename='BINOY'; "
    and if i write same query with different data set will it be parsed again. or no parsing will be done by oracle server.

    for ex : if i write same query like this :

    " select * from emp where ename='VINAY'; "
    then will it be parsed again.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    so... what's your question?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2006
    Posts
    86
    my question is
    if i write same SQL with different data sets then will that query be parsed by oracle server or not
    since the commands resides in libraray cache.

    also tell me is there any way to sort out mutating table trigger error other than Autonomous Transaction

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    1- Query Parsing when using Literals

    Your queries might look similar but are different, Oracle will parse your query each time you submit it.
    Use bind variables.

    2-Mutating Table caused by Trigger

    In the Oracle world you don't want to have a trigger pointing to the same table the trigger is sitting in. Very bad mojo.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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