What is the main functionality of Prepared Statement?
Answers were Sorted based on User's Feedback
Answer / madhu
it is wrong assumption that preparedStatement is precompiled statement,because when we send any query with prepared statement it is going to store in SGA memory and it select any algorithm to find the solution.when we send the same query second time it won't compile once again.in this it going to improve performance.for the first time it is not precompiled for the second it is precompiled.
i hope is correct, if any thing wrong suggest me.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / arjun
when client send any query first time it can go to database
after second time no need to connect directly connect
database that is the functionality
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / md sirajuddin
Prepared Statement is an interface , which is used to execute queries . In case of prepared Statement we can insert the data dynamically to the query , prepared statement is used to execution query multiple times.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why object class is super class for every class in java?
what is synchronization? : Java thread
what is the difference between Cpp And Java
What is immutable in java?
what is the replacement for GOTO in java?
what is the purpose of the final in the try-catch-final
What are white spaces in java?
Relationship between an event-listener interface and an event-adapter class?
What is difference between pointer and reference?
Can classes declared using the abstract keyword cab be instantiated?
How to sort an unsorted array in java?
why java is not supporting multiple inheritence?