Re: O9i: bind variable questions (special)

On Apr 5, 2:29 am, Andreas Mosmann <mosm..._at_expires-30-04-2007.news- group.org> wrote:

> so there are 3*3*2*2*2*(2 or many) different versions, in best case
> about 150 different queries.

Also see http://jonathanlewis.wordpress.com/2007/01/05/bind-variables/ and http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7832114438832

Bind variable peeking may bite you, using nulls incorrectly may nullify index use.

jg

--
@home.com is bogus.
"After the meeting she told me she reads my blog. She didn't chew me
out about the content. I was happy." - Kevin Closson