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
Course Formats
This course is available as:
- Instructor led training
- e-Learning
- Book
- Any combination of the 3 options
Audience
- End User
- Implementer
- Manager
Topics
- 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…