i'm writing stored function called make_email
accept input arguments first name , lastname , return varchar2
value containing email address in form of first initial of firstname followed full last name followed @hpu.edu.
ex: calling select make_email('edward','souza')
dual return single value: esouza@hpu.edu
here code:
create or replace function make_email(lastname varchar2(10),firstname varchar(10)) return varchar f_name varchar; l_name varchar; begin return end make_email; /
could please me how achieve goal? i'm new in pl/sql.
try this
create or replace function make_email(lastname varchar2(10),firstname varchar2(10)) return varchar email varchar2; begin email := substr(lastname ,1,1)|| firstname || '@hpu.edu'; return email; end;
Comments
Post a Comment