Re: Question about using bind variables in static sql

Sorry wasnt clear...

Select
From
where dept = &dept
in SQLPLUS

vs.

Select
from
where dept = :dept

vs

select
from
where dept = v_dept(this is a host variable)

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<%fVj8.34431$af7.28397_at_rwcrnsc53>...
> 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 Thu Mar 14 2002 - 06:50:21 CST