what is difference between procedure and function

Answer Posted / monalisa dalbehera

Function always return a single value
Procedure may or may not return a value.
A procedure can return more than one value by using out
parameter.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run pl sql in sql developer?

904


What are the rules to be applied to nulls whilst doing comparisons?

1055


What is data control language (dcl)?

826


What is benefit of creating memory optimized table?

745


What is the reports view in oracle sql developer?

756


What is the example of procedure?

716


What is string join?

777


What are the types of join and explain each?

809


how to load data files into tables with 'mysqlimport'? : Sql dba

815


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

814


What is the use of <> sql?

769


how to show all tables with 'mysql'? : Sql dba

858


What is the difference between left outer join and left join?

744


What is java sql connection?

751


What is a file delimiter?

787