Stored procedure purpose?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?

486


How can we retrieve the file in the oracle database?

509


How can I create a custom RowSetMetaData object from scratch?

542


What are the differences between stored procedure and functions?

468


What is represented by the connection object?

521






Which type of driver is unique in jdbc?

486


State the three different ways in which you can create a table?

512


How to check jdbc driver version in websphere?

541


How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

523


What is a datasource in java?

496


Explain how to make updates to the updatable resultsets.

497


Is jdbc faster than odbc?

500


What are the different types of classes in the api component?

526


What are the considerations for deciding on transaction boundaries?

554


What is jdbc resultsetmetadata interface?

522