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

Can we use rowid as primary key?

965

how to shut down the server with 'mysqladmin'? : Sql dba

990

What is view explain with example?

919

what is heap table? : Sql dba

1090

Can we use two order by clause in query?

948

What is a native sql query?

1040

what is 'mysqladmin' in mysql? : Sql dba

1009

Why is theta join required?

1122

What are predefined functions in sql?

1021

What type of database is sql?

1015

How many types of literals are available in pl sql?

1095

what are the disadvantages of mysql? : Sql dba

1129

Is natural join and inner join same?

901

What is meant by cursor in sql?

972

How do you use a while loop in pl sql?

990