Hi, Basic Difference is Function must return a value and Procedure can

What is difference between Procedures and Functions ?

Question Posted / guest

Answer Posted / guest

Hi,

Basic Difference is Function must return a value and
Procedure can or cannot return a value using out parameter.

Thanks!

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are all the different types of indexes? : Sql dba

713

What is input buffer in sql*plus?

825

what is index? : Sql dba

746

Can a foreign key be null?

809

what is the difference between join and union? : Sql dba

718

What is clustered index in sql?

782

what are the different type of sql's statements ? : Sql dba

697

How to write html code in pl sql?

800

What are the types of join and explain each?

770

Which command is used to call a stored procedure?

713

How can check sql version from command line?

716

How many columns should be in an index?

704

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

809

What is embedded sql what are its advantages?

688

What is the difference between local and global temporary table?

751