Re: Using bind variables

From: Dave <x_at_x.com>
Date: Mon, 18 Apr 2005 20:03:11 GMT
Message-ID: <3oU8e.15038$G8.11681@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 Received on Mon Apr 18 2005 - 15:03:11 CDT