adspace


Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Answer Posted / deepak

Note:- procedure may or may not return value.function must
return value
Procedure return one or more value & function return only
single value.
Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.
Package & packagebody are two different thngs. Variable
defined in packages are global & they can use in anywhere
in packagebody. Variable defined in packagebody have
limited scope. & they can used in defined limit only.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

please send me oracle pl/sql exp resume. and also faqs...

2588


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2372