Correlated Subquery vs Nested query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Correlated Subquery vs Nested query

  1. #1
    Join Date
    May 2001
    Location
    Boston
    Posts
    24

    Question Correlated Subquery vs Nested query

    Hi,

    I have a couple of questions below.

    1) Which one is faster?
    correlated subquery or nested query.

    2) Which one is efficient?
    SQL*Loader or UTL_FILE

    3) Can I use DECODE function in a query within PL/SQL block.

    I appreciate your reply for the above.

    Thanks.

    RaviShankar.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    try by urself, will know better.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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