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 do I connect to jdbc?
What is resultsetmetadata?
what is meant by connection pooling?
What is jdbc and its types?
Is jdbc secure?
Why prepared statements are faster?
What is Statement and PreparedStatement? whatz the difference?
What are the methods which can verify the cursor particular position?
MY code is: public class P1{ public static void main(String ar[]) { class.forName("java.lang.String"); } } errors i got are :New.java:5: error: <identifier> expected class.forName("java.lang.String"); ^ New.java:5: error: invalid method declaration; return type required class.forName("java.lang.String"); ^ New.java:5: error: illegal start of type class.forName("java.lang.String"); ^ New.java:7: error: reached end of file while parsing } ^ 4 errors HELP ME>......
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What is a rollback in jdbc?