PL/SQL ORACLE 11g Programming 2E

Assignment 7-6

Create a package consisting of only a specification. The Brewbeans lead programmer has noticed that only a few states require internet sales tax, and the rates dont change often. Create a package named tax_rate_pkg to hold the following tax rates in package variables for reference:

pv_tax_nc = .035

pv_tax_tx = .05

pv_tax_tn = .02

Code the variables to prevent the rates from being modified. Use anonymous block with dbms_output statements to display the value of each package.

Please use SQL Developer to answer