PL/SQL ORACLE 11g Programming 2E

Assignment 7-7

In this assignment, you work with the sales tax computation because the Brewbeans lead programmer expects the rates and states applying the tax to undergo some changes. The tax rates are currently stored in package 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 what rates. This package should contain a function that can receive a two-character state abbreviation (the shoppers state) and 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 value NC.

Please use SQL Developer to answer