Create function called getEmpLastName that takes as parameter employee id value and returns employee's last name. Remember
Fantastic news! We've Found the answer you've been seeking!
Question:
Create function called getEmpLastName that takes as parameter employee id value and returns employee's last name. Remember to put exception toward the very end of the function.
Template:
CREATE OR REPLACE FUNCTION getEmpLastName ( parameters )
RETURN datatype IS
variables; (Optional)
BEGIN
code;
RETURN expression;
EXCEPTION
WHEN OTHERS THEN
RETURN 'NO EMPLOYEE FOUND';
END;
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-0078025914
5th edition
Authors: Fred Phillips, Robert Libby, Patricia Libby
Posted Date: