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
- 12157 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 device controller?
How do I know which jdbc driver to use?
What is odbc and jdbc drivers?
Is jdbc a protocol?
explain about special characters?
Is it possible to connect to multiple databases simultaneously?
Why do we use jdbc in java?
Which package contains jdbc api?
What is the meaning of “dirty read” in the database?
Is jdbc and orm?
What are the advantages of database connection pooling?
What is jdbc architecture?
Is there another way of dealing with the result set that could execute faster?
Why we use while rs next ())?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
