Function always return a single value Procedure may or may not return a va

what is difference between procedure and function

Question Posted / monalisa dalbehera

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

Please Help Members By Posting Answers For Below Questions

What are triggers and its uses?

997

Explain what is a column in a table?

1038

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1057

How we can update the view?

1004

What is the usage of distinct keyword?

1017

Is json a nosql?

914

How does stored procedure reduce network traffic?

965

How do you define a foreign key?

937

How do I view tables in sql developer?

881

What is error ora-12154: tns:could not resolve the connect identifier specified?

1013

When can we use the where clause and the having clause?

966

What is crud diagram?

877

What is a record in a database?

989

What does data normalization mean?

896

How many databases can sql express handle?

939