Interested to Buy Any Domain ? << Click Here >> for more details...
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?................
- 6 Answers
- 12564 Views
- TCS, I also Faced
- E-Mail Answers
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
What is jdbc thin client in oracle?
What is database deadlock ? How can we avoid them?
How many types of resultset are there in jdbc?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
What is jdbc and jdbc drivers?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
What is JDBC Batch Processing and what are it’s benefits?
What is JDBC Statement?
Which jdbc drivers will run your program?
What are the common JDBC problems that you got and how do you solved them?
What are the common tasks of JDBC?
What does setautocommit do?
How can we maintain the integrity of a database by using jdbc?
Which database is used with java?
