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

This course is available as:

  • Instructor led training
  • e-Learning
  • Book
  • Any combination of the 3 options
  • End User
  • Implementer
  • Manager
  • System Defined Functions
  • Advantages of Stored Procedure
  • Package Syntax
  • Package Body
  • Syntax for Sequences
  • Syntax for Triggers
  • Syntax for Error Handling
  • User Defined Exceptions and Error handling
  • Package Specification Example
  • And many more…