FUNCTION PROCEDURE and PACKAGE

Question

Hi friends Explain the difference between a FUNCTION PROCEDURE and PACKAGE.

Satyapriya Nayak · Answer

Hi Akshay Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:10.0pt;font-family:Times New Roman;} Package::-It stores and compiles all the functions and procedures declared in SGA(System Global Area).Whenever stored procedures or functions are called from this package it will get them from SGA.So it performance is definitely high. Procedures::-They are subprograms which perform certain action. They cannot be called from select statement. Functions::-They are subprograms which return a value. They can be used in select statement and also its return value can be assigned to a variable. Please refer the below link http://www.brilliantsheep.com/difference-between-plsql%E2%80%99s-function-procedure-and-package/ Thanks

FUNCTION, PROCEDURE and PACKAGE