Unanswered: How to return customized format in PL/SQL?
I'm writing a stored function called MAKE_EMAIL that will accept input arguments for first name and lastname and will return a varchar2 value containing the email address in the form of first initial of the firstname followed by the full last name followed by @hpu.edu.
Ex: Calling select make_email('Edward','Souza')from dual would return the single value: 'firstname.lastname@example.org'
Here is what I have come up with:
create or replace function MAKE_EMAIL(lastname varchar2(10),firstname varchar(10))
return VARCHAR IS
Could anyone please help me how to achieve the goal? I'm new in PL/SQL.