"Dave" <x_at_x.com> wrote in message
news:3oU8e.15038$G8.11681_at_text.news.blueyonder.co.uk...
>
> "Randy Harris" <randy_at_SpamFree.com> wrote in message
> news:UmU8e.108$fw2.45_at_newssvr33.news.prodigy.com...
> > "Dave" <x_at_x.com> wrote in message
> > news:GbU8e.15030$G8.11877_at_text.news.blueyonder.co.uk...
> >>
> >> "Randy Harris" <randy_at_SpamFree.com> wrote in message
> >> news:38U8e.105$fw2.3_at_newssvr33.news.prodigy.com...
> >> > The first chapter of "Expert One-On-One Oracle" makes it abundantly
> > clear
> >> > why bind variables should be used, rather than string literals, in
> >> > queries.
> >> > I haven't yet figured out how to use them in a view and would
> >> > appreciate
> > a
> >> > pointer in the right direction.
> >> >
> >> > create or replace view myview as
> >> > select col1, col2, col3
> >> > from t
> >> > where
> >> > t.col3 in ('A', 'B', 'C')
> >> >
> >> > How should I change that to use a bind variable?
> >> >
> >> > I'm using 8.1.7.4
> >> >
> >> > --
> >> > Randy Harris
> >> > (tech at promail dot com)
> >> >
> >> >
> >>
> >> you dont need binds there, the values never change
> >>
> >
> > I thought I understood Tom Kyte to say that if there are literals in the
> > SQL, Oracle has to recompile the statement every time it is run, but if
> > not,
> > it remains compiled. Am I confused?
> >
> >
> >
> >
>
> only if the literals change which in a view they dont, its all about
shared
> sql and that sql is shareable
OK-thanks
Received on Mon Apr 18 2005 - 15:07:04 CDT
