Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using bind variables
"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 Received on Mon Apr 18 2005 - 14:49:58 CDT