Re: [newbie] bind variables

"Franz" <franz_at_mail.com> wrote in message news:q4%2b.268595$Ny5.8263211_at_twister2.libero.it...
> Hi all,
> I'm using a SQL statement from inside a Java function.
> The statement is a PreparedStatement, that is:
>
> select * from table1 where field1 = ?
>
> then in the code I set at runtime "field1" with the desired value.
> Now my question is: will Oracle use bind variables when I issue a
statement
> like
> this ? I'd like to avoid to have my statement re-parsed every time.
>
> A further question: how do you check on the DB that a statement has been
> parsed ?
>
> Thanks a lot
> Frank
>
>
>
>

1 Oracle will use bind variables
2 You don't need to, as you have control over that yourself.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address