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
- 12378 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 the purpose of jdbc resultset interface?
What protocol does jdbc use?
Where can I find ojdbc14 jar file?
What do you understand by jdbc driver and explain its types?
What is the role of class.forname while loading drivers?
What are the advantages of database connection pooling?
What are the different types of JDBC drivers?
What is the use of statement in jdbc?
What is jdbc vs odbc?
What are the advantages of using preparedstatement in java?
How do you insert images into database using jdbc?
How can we set null value in jdbc preparedstatement?
What is a jdbc connection?
What are clob and blob data types in jdbc?
Why do you use a data source object for a connection?
