Interested to Buy Any Domain ? << Click Here >> for more details...
Stored procedure purpose?
- 2 Answers
- 5934 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 is execute in java?
If I use the JDBC API, do I have to use ODBC underneath?
How do I set properties for a JDBC driver and where are the properties stored?
What port does jdbc use?
What is jdbc in dbms?
What is the execute method in java?
How do I find ojdbc jar version?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
wa is connection pooling? how do u create connection pooling?wat is use connection pooling?
What is the role of class.forname while loading drivers?
What is database connection pooling? Advantages of using a connection pool?
What is jdbc and why is it required?
Core Java 
