Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question about using bind variables in static sql

Question about using bind variables in static sql

From: Ryan Gaffuri <rkg100_at_erols.com>
Date: Wed, 13 Mar 2002 21:06:37 -0400
Message-ID: <a6p2tl$35a$1@bob.news.rcn.net> 





I know this improves performance in dynamic sql. Does it improve performance
in standard sql? When would you want to use a bind variable in static sql?
How does the way Oracle handles a bind variable in standard sql differ from
how it handles a & variable?



Thanks
Received on Wed Mar 13 2002 - 19:06:37 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US