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 sql servers linked to other servers like oracle? : Sql dba

545

What is the use of <> sql?

548

How is sql used in oracle?

575

What is character functions?

552

What is nosql db?

533

How to execute a stored procedure?

557

Can I create table without primary key?

525

What is the difference between distinct and unique in sql?

464

Which is better join or subquery?

598

What are all the common sql functions?

555

What is rowtype?

559

What are hotfixes and patches?

521

How do I save the results of sql query in a file?

531

In pl/sql, what is bulk binding, and when/how would it help performance?

525

What is a natural join sql?

509