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 does jdbc stand for?
What does executeupdate return in java?
What is statement and resultset in jdbc?
What is the query used to display all tables names in SQL Server (Query analyzer)?
Without using of Class.forName(? ?), how do you connect to db?
How do I stop nullpointerexception?
What does executeupdate return in jdbc?
What is 2-tier and 3-tier architecture?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
What is the latest version of JDBC? What are the new features added in that?
What is a Connection?
How do you determine the sensitivity of the ResultSet object?