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 |
How does a custom RowSetReader get called from a CachedRowSet?
What is resultset in jdbc with example?
How can a java objects be stored in database?
What is jdbc databasemetadata interface?
If iam using JDBC API, do I also have to use ODBC?
What are the common tasks of JDBC?
State the different connection methods used for creating different types of sql.
What are restrictions on triggers?
Explain the importance of drivermanager.
Why resultset is used in java?
What is a Connection?
What happens if connection is not closed in jdbc?