Question: what is difference between package and procedure in oracle?
Answer: Function: The main purpose of a PL/SQL function is generally to compute and return a single value. ... A procedure is used to return multiple values otherwise it is generally similar to a function. Package: A package is schema object which groups logically related PL/SQL types , items and subprograms.