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
- 12101 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 do you mean by metadata and why we are using it?
How many ways can you update a result set?
When does the result for an sql statement return null?
How to rollback a JDBC transaction?
How do we load the drivers?
Explain about Join?
How can I retrieve a String or other object type without creating a new object each time?
What are the different types of interfaces in the api component?
What is jdbc connection?
What do you mean by odbc?
How does a custom RowSetReader get called from a CachedRowSet?
Explain about multiple implementations and drive manager?
What are the three parts of a jdbc url?
What is jdbc explain?
What is ojvm used for?
