Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about using bind variables in static sql
Not exactly sure what you mean?
do you mean
select ... from ... where dept='mydept'
vs
select ... from ... where dept=:hvDept
?
If so the 2nd one (has bind variables) is better if another session does the
same thing
select ... from ... where dept=:hvDept
vs
select ... from ... where dept='hisDept'
See the documentation for Application development.
Jim
"Ryan Gaffuri" <rkg100_at_erols.com> wrote in message
news:a6p2tl$35a$1_at_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 - 22:00:59 CST