What is difference between a PROCEDURE & FUNCTION ?

Answer Posted / chandrasekar.ramasamy

Function accepts only in parameter but procedure accepts
in,out and inout
Function mostly used for mathamatical calculations
But procedure used to execute business logics

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use in conditions? : Sql dba

514


What are the basic techniques of indexing?

577


how to calculate expressions with sql statements? : Sql dba

532


What is the process of copying data from table a to table b?

600


explain primary keys and auto increment fields in mysql : sql dba

535






Why is sql important?

583


Is grant a ddl statement?

453


what is bdb (berkeleydb)? : Sql dba

574


How do I save a sql query?

546


What is function and procedure in pl sql?

522


What is left inner join in sql?

519


What is sql prepared statement?

545


what is a field in a database ? : Sql dba

547


What problem one might face while writing log information to a data-base table in pl/sql?

558


Is natural join and inner join same?

500