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 is serialization and deserialization in java programming?
What is jdbc architecture?
What is 2-tier and 3-tier architecture?
what is the current version of JDBC? and explain its features?
What are types of jdbc drivers?
How to check null value in JDBC?
What is the return type of class.forname() method?
How can we store and retrieve images from the database?
What is encrypted connection?
Write a program JDBCcode forfetching student database with SQL.
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
How do I find jdbc version?