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 a jdbc connection?
What is “dirty read” in JDBC? Which isolation level prevents dirty read?
how you will execute the many tables data
What is the difference between jdbc and jndi?
Is possible to open a connection to a database with exclusive mode with JDBC?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
Is JDBC a language or Application?
What is the jdbc rowset?
how to retrieve sql exceptions
How can you sort dates?
What is namedparameterjdbctemplate?
What is the use of the statement in jdbc?