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
How do I disallow NULL values in a table?
Explain about column name and getter method?
Why is odbc needed?
When do we use execute method in java jdbc?
Which type of JDBC driver is the fastest one?
Does jdbctemplate close connection?
How many locking systems are there in jdbc?
What is drivermanager in java?
What is the meaning of connection?
What is resultset?
What is jdbc in java?
What are the differences between resultset and rowset?
What is a rollback in jdbc?
Explain the various types of locking system in jdbc?
How to connect html page to database using jdbc?