Oracle 11g

Table Required:

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.

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