Create Function in (PL/SQL)
called lookup_user (v_email)
Return the user number of the given user or -1 if the user is not found.
Table Account (this is the table I need to add data using Function)
Account_no (PK)
Email (VARCHAR2)
first (VARCHAR2)
last (VARCHAR2)
Table has been created and data inserted
PL SQL Function code
Return the user number of the given user if user is found (Code and output as screenshot)
Return -1 if the user is not found (Code and output as screenshot)
Get Answers For Free
Most questions answered within 1 hours.