Parameterized cursors v15
You can declare a static cursor that accepts parameters and can pass values for those parameters when opening that cursor. This example creates a parameterized cursor that displays the name and salary of all employees from the
emp table that have a salary less than a specified value. This information is passed as a parameter.
For example, if you pass the value 2000 as
max_wage, then you see only the name and salary of all employees that have a salary less than 2000. The following is the result of the above query: