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
What is JDBC Savepoint? How to use it?
How many types of resultset are there in jdbc?
What are the standard isolation levels defined by JDBC?
What is jdbc connection?
What are the different types of statements? How we can you use preparedstatement.
What is the meaning of “dirty read” in the database?
Explain the main method?
How to check jdbc driver version in websphere?
What is data source in java?
What are the steps required to execute a query in jdbc?
What is the advantage of namedparameterjdbctemplate?
Is jdbc an api?
List the advantages of using datasource?
What is metadata in java programming?
Describe how the jdbc application works.