What is difference between Procedures and Functions ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

6 Answers
10370 Views
Hi Caliber IT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is difference between Procedures and Functions ?..

Answer / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Is This Answer Correct ?

5 Yes

0 No

What is difference between Procedures and Functions ?..

Answer / 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

What is difference between Procedures and Functions ?..

Answer / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Is This Answer Correct ?

2 Yes

0 No

What is difference between Procedures and Functions ?..

Answer / shasi

Hi,

The main think is function canbe used in sql select
statement but procedure wer can't use.procedure redurn more
then value(max:1024)funcion must return 1 value

Is This Answer Correct ?

1 Yes

0 No

What is difference between Procedures and Functions ?..

Answer / sandeep sahoo

Prcocedure Will do Action whereas Function Will do Calculation

Is This Answer Correct ?

0 Yes

0 No

What is difference between Procedures and Functions ?..

Answer / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

Is This Answer Correct ?

1 Yes

5 No

Post New Answer