Oracle functions, procedures, packages

IN, OUT and INOUT are the arguments that are passed to the procedures. IN is a 'read only' argument and must be initialised.....
Packeges are PL/SQl constructs that allow related data to be stored together. A package has two parts: specification and a body......