Oracle 11g

Table:

1. Create a function that accepts a username and password as arguments and verifies these values against the database for a match. If a match is found, return the value Y. Set the value of the variable holding the return value to N. Include a NO_DATA_FOUND exception handler to display a message that the logon values are invalid. 2. Now place the function in a package, and add code to create and populate the packaged variables specified earlier. Name the package LOGIN_PKG. 3. Use an anonymous block to test the packaged procedure, using the username gma1 (it is gma and the number one) and the password goofy to verify that the procedure works correctly. Use DBMS_OUTPUT statements in an anonymous block to display the values stored in the packaged variables. This includes the shopper ID and the first three digits of the shopper's zip code.

EDIT IDSHOPPER FIRSTNAME LASTNAME ADDRESS CITY STATE ZIPCODE PHONE FAX USERNAME PASSWORD COOKIE DTENTERED PROVINCE COUNTR 21 Front 13-JAN- 2012 21 NC 9014317701 Crackjack@acom Crackj flyby MargaretSomner Walnut Chessapeake VA 23321 7574216559-MargSDinfi.net Marys 03-FEB-2012 1 Fun 26 JAN 2012 23 outh Park NC 54674 9015680902 rat55 40162 Talamore outh Riding A 20152 11 Pine 19-MAR 2012 7035556868- kids2@xis.net 7578221010 scottlDodu.edu 19-FEB-2012 - 112 W Greensburg 27754 26 7573217384 - gmaearth.net gmal 09-FEB-2012 USA 4th 1 Queens New York NY 67233 1013217384- spider@web.net 14-FEB-2012