That's good to know and it makes a lot of sense now. Thanks!
--- "Barr, Dan" <[EMAIL PROTECTED]> wrote:
> Some versions of Oracle are smart enough to figure out they're the
> same
> (starting with 9i I think). However, the:
> INSERT INTO mytable VALUES('a','B','CC');
> is replaced by
> INSERT INTO mytable VALUES(:1,:2,:3); // In database-speak
> if you use a PreparedStatement object with ? where the bind
> variables go
>
> so the statement parsed is really something like the third one,
> which is the
> same in both your examples (just the values changed)...
>
>
> -Dan
> [EMAIL PROTECTED]
> http://www.compuware.com/products/devpartner/db/oracle_debug.htm
>
>
> > -----Original Message-----
> > From: Jason Kilgrow [mailto:[EMAIL PROTECTED]]
> >
> > I can only assume that this applies to PreparedStatements as
> well.
> > For instance, Oracle says that:
> > INSERT INTO mytable VALUES('a','B','CC');
> > is different than
> > INSERT INTO mytable VALUES('d','E','FF');
> > Therefore, the second query has to be reparsed/recompiled. No?
> That's
> > my apprehension about using PreparedStatement. But, I guess
> Oracle is
> > magic enough to see the similarities and cache the query enough
> so
> > that only a parameter replacement takes place.
> >
> > Unless...unless it treats the question marks like ampersands (&)
> in
> > the SQL...then that would make sense to me because then Oracle
> will
> > ask for replacement values for each question mark much the same
> as it
> > would if you were executing the query with & in place of ? in
> > SQLPlus. I'm just guessing at this point, however.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> >
> > To change your membership options, refer to:
> > http://www.sys-con.com/java/list.cfm
> >
>
>
>
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it.
>
>
> To change your membership options, refer to:
> http://www.sys-con.com/java/list.cfm
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
To change your membership options, refer to:
http://www.sys-con.com/java/list.cfm
