What are main difference between Stored Procedure and
Functions.

Answer Posted / guru

stored procedure : It is Pre Compiled Code(PCode) it is stored
in Database. we can reuse without compile.

Function: It need compile whenever it will run.

Is This Answer Correct ?    15 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should I use oracle database?

736


How to rename an index?

777


How to install oracle database 10g xe?

753


What is partitioned table in Oracle?

818


How to use subqueries in the from clause in oracle?

796






What is query image?

730


Does oracle charge for java?

785


What language does oracle use?

809


How many file formats are supported to export data?

855


What is a cursor and what are the steps need to be taken?

766


How to add another datafile to a tablespace?

788


How do I spool in oracle?

710


Explain do view contain data?

756


What is bulk collect in oracle?

736


What privilege is needed for a user to insert rows to tables in another schema?

768