Re: Database

Posted by ErmanArslansOracleBlog on Oct 09, 2017; 8:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Database-tp3890p3896.html

There are lots of related articles and comments about this topic.

You need to read PLSQL tutorials, in the first place.

Basically, functions must return a value. However, retuning a value is not a must for procedures.
A stored procedure cannot be used in a select statement. The functions, however; can be used in a select statement .
Packages are collections of procedures, functions, types, and variables.