what diffrence between function and procedure?

Question Posted / mnoj

4 Answers
6457 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what diffrence between function and procedure?..

Answer / deepu

functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.

Is This Answer Correct ?

1 Yes

0 No

what diffrence between function and procedure?..

Answer / manu sankar

Functions can be called inside a sql but procedures cannot

Is This Answer Correct ?

1 Yes

0 No

what diffrence between function and procedure?..

Answer / pr@$@d

Hi Raj ,

Nice answer,

We can use OUT,INOUT also in function but it is not
suggested by Oracle.

Thanks,
-Pr@$@d.
prasadreddi@ymail.com

Is This Answer Correct ?

1 Yes

0 No

what diffrence between function and procedure?..

Answer / raj dhar

Function :- Function always return one value.
Procedure :- Procedure may or may not be return value.

Function :- Function always required " RETURN " key word.
Procedure :- Procedure doesn't require " RETURN" key word.

Function :- Function we use parameter IN.
Procedure :- Procedure we use parameter IN,OUT,INOUT.

etc.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer