Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Unanswered: Dynamic or Static SQL is better?

    Hi all,
    I knew that using Dynamic SQL is always a better solution especially using it with bind variables(Thanks Tom Kyte
    But recently I read a paper that noted many opposite and odd thins to me such as using static SQL is better in client side and also using thin driver for jdbc programs increase performance more than oci drivers!
    you could find this paper at :
    http://www.onjava.com/pub/a/onjava/...LL-4GV796923290
    please offer your opinion about this confusing material.
    -thanks

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    You should not cross-post .

    To anyone interested, answer here.

    Regards,

    RBARAER

Posting Permissions

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