This question is related to pl/SQL:-

Using a Cursor in a Package

In this assignment, you work with the sales tax computation because the Brewbean's lead

programmer expects the rates and states applying the tax to undergo some changes. The tax

rates are currently stored in packaged variables but need to be more dynamic to handle the

expected changes. The lead programmer has asked you to develop a package that holds the

tax rates by state in a packaged cursor. The BB TAX table is updated as needed to reflect

which states are applying sales tax and at what rates. This package should contain a function

that can receive a two-character state abbreviation (the shopper's state) as an argument, and it

must be able to find a match in the cursor and return the correct tax rate. Use an anonymous

block to test the function with the state value NC.