Stored procedure purpose?
- 2 Answers
- 4669 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / samsudeen
Hi Desika, pls undesrstand the question, he/she asking the
purpose of SP.
1) Stored Procudure is a collection of sql statements
2) Faster then Sql Qury
3) Preformance Tuning
4) resuable.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / desika
A Stored Procedure is used to separate business logic from
Presentation logic,advantage of implementing a business
logic as storedprocedures improves the performance and we
can use same code for the applications written in other
languages.
| Is This Answer Correct ? | 3 Yes | 2 No |
What are temp tables ?
Is possible to open a connection to a database with exclusive mode with JDBC?
what does batchUpdate does?
What are the factors that the jdbc driver performance depends upon?
what are the drawbacks of JDBC? explain briefly?
What is the equivalent method for precompiled SQL Statement in JDBC?
What are the advantages of using preparedstatement in java?
Is jdbc part of j2ee?
What is meant by connection string?
How are jdbc statements used?
Does jdbctemplate close connection?
Explain the different ways to register a driver?
Core Java 
