diff b/w function and procedure?

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

Question Posted / g.rajesh

9 Answers
15309 Views
iFlex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

diff b/w function and procedure?..

Answer / rupesh

function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement

Is This Answer Correct ?

15 Yes

1 No

diff b/w function and procedure?..

Answer / muhammad sohail

function can be use in select clause and where clause
procedure can't

Is This Answer Correct ?

7 Yes

0 No

diff b/w function and procedure?..

Answer / vipin kumar (m.c.a)

For calling both have the different method--
To call function

variablename:=functionname(arguments);

To call procedure

procedurename(argumentlist);

Is This Answer Correct ?

6 Yes

0 No

diff b/w function and procedure?..

Answer / tilak

1)we can write COMMIT in procedure but we cant write in function

2) function must me return a value but procedure may or may
not be

Is This Answer Correct ?

8 Yes

3 No

diff b/w function and procedure?..

Answer / vishal

procedure have two type of parameter intput and output type
but function have only one

Is This Answer Correct ?

9 Yes

6 No

diff b/w function and procedure?..

Answer / sankaranarayanan.c

Procedure return more than one value, but fuction can
return only on value.

Is This Answer Correct ?

6 Yes

5 No

diff b/w function and procedure?..

Answer / gourvendra singh

A procedure a subprogram used to perform a specific action
whereas a function is a subprogram which is used to compute
a value,in procedure we can use parameters(IN,OUT,IN OUT)
but in function we cant

Is This Answer Correct ?

4 Yes

4 No

diff b/w function and procedure?..

Answer / sanjai yadav

function must have return type but a procedure may or may not have return type?

function:- int a= sum();

procdure:- sum();

Is This Answer Correct ?

0 Yes

0 No

diff b/w function and procedure?..

Answer / malkeet kaur

1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done

Is This Answer Correct ?

0 Yes

0 No

Post New Answer