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 to rollback a JDBC transaction?
How to invoke Oracle Stored Procedure with Database Objects as IN/OUT?
What are the differences between statement and preparedstatement interface?
Which jdbc drivers will run your program?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
What are the advantages of using jdbc datasource?
What is JDBC Savepoint? How to use it?
What are temp tables ?
what happen if we set JDBC string to NULL?
If you are truncated using JDBC, how can you that how much data is truncated?
What is jdbc and explain jdbc architecture?
What is Type-2 Driver and when this driver is used?