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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using bind variables

Re: Using bind variables

From: Randy Harris <randy_at_SpamFree.com>
Date: Mon, 18 Apr 2005 20:01:56 GMT
Message-ID: <UmU8e.108$fw2.45@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? Received on Mon Apr 18 2005 - 15:01:56 CDT

Original text of this message

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