Stored procedure purpose?
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 the jdbc statements?
What is jdbc thin client?
Which is better jpa or jdbc?
What are the different types of drivers under jdbc?
Why do we use jdbc statements?
What is a statement?
Which Java and java.sql data types map to my specific database types?
Is jdbc a framework?
What is execute(), executeUpdate() and executeQuery() methods?
State the three different ways in which you can create a table?
What is 2 phase commit?
How does jdbc driver work?