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 can I connect mysql or oracle with java?
what is meant by connection pooling?
Does sql allow null values ?
What are the steps to connect to the database in java?
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What is an encrypted internet connection?
How can I create a custom RowSetMetaData object from scratch?
What driver should I use for scalable Oracle JDBC applications?
When do we get java.sql.SQLException: No suitable driver found?
How are jdbc statements used?
In JDBC, All the API?s are interfaces? Where is the actual implementation?
How to check null value in JDBC?