Oracle Stored Procedures
- A Function is a subprogram similar to that of stored procedure, except that a function must always return a value.
- Only select statements can be written inside the function, No DML statements like Insert, Update and delete can be written inside a function.
- A function contains three most important parts declarative part, execution part and the last one is exception handling part.
Most important advantage of using a function is that it provides data encapsulation(data hiding