Both(functions and Procedures) are the Oracle Objects that work explicitly towards database objects like Tables,Views.

The diff. b/t Stored Procedures and Functions

1) The procedures doesn't return values. whereas the function returns value.

2) The procedures accept more than one argument whereas the functions not.

both the procedure and functon accept more than one variable.Function do not have an out variable where as procedures return variable to the calling environment using out variables not the return cluase where as function return value using return clause.and it must return a value but procedure may or maynot.

1) Function may return a value whereas procedure may or may not return value.
2) Function cannot accept parameter but procedure accept parameter.
3) We can call function in a select statement with clauses but procedure doesn't.
4) We cannot use INSERT,UPDATE,DELETE in function.
5) Procedure is used as a statement in a PL/SQL block whereas Function is used as a expression in a PL/SQL
block.

If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question