With this module, you have received a brief introduction to Advanced Queuing.
Even though the basic operations that are used with Advanced Queuing are fairly simple, the amount of flexibility built into this feature allows an incredible range of implementation scenarios.
In this lesson, you learned how to:
- Define Advanced Queuing and the entities involved
- Describe important data dictionary views that contain information about Advanced Queuing
- Describe the prebuilt PL/SQL packages used to create an Advanced Queuing application
- Use PL/SQL to create an Advanced Queuing application
- Set up enqueuing to the Advanced Queue
- Set up dequeuing from the Advanced Queue
- Set up propagation functionality with PL/SQL
- Run the application you have created with Advanced Queuing
We have only scratched the surface of the many different ways you can use Advanced Queuing, but you should have a basic understanding that will allow you to use this feature as you plan your applications.
The following terms were defined in this module:
- Asynchronous: A process where a command is submitted and the submitter does not wait for a response from the recipient of the command.
- Package: A group of PL/SQL procedures that are combined into a single logical grouping. The package header contains the interface description for the procedures, whereas the package body contains the actual code for the procedures in the package.
- Procedure: Uses PL/SQL code and syntax to implement a logical operation.
- Type definition: Defines an Oracle object type.
- Wrapper: Code that wraps a type of logic with some other code to make a cleaner interface.
In the next module, you will learn about working with large objects in Oracle.