What is the use of prepared statement?Ans:used to execute
pre compiled statement...so the question is when that
precompiled statement will be execute or
comiple?................
Answer Posted / suri
when we sent a sql stmt in to oracle sever the server
splits statemts in to mutiple stmts, checks wheather valid
or not, if it is valid it is stored in the shared pool,
where as in the normal stmt parsing will be done every time
in prepared parsing will be done only once, naxt time
onwards values will be sent to the place holders
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Is oracle client required for jdbc connection?
Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
Why we use while rs next ())?
How to update a resultset programmatically?
What are the different types of statements? How we can you use preparedstatement.
How can we store and retrieve images from the database?
What is the use of callablestatement? Name the method, which is used to prepare a callablestatement.
What are JDBC Best Practices?
What is the use of statement in jdbc?
Which type of driver provides jdbc access via one or more odbc drivers?
What is an escape syntax?
Which database is used for java?
Give an example for execution of sql statement.
What is jdbc dialect?
Why do we need jdbc driver?