Child pages
  • Seperate Domain from EMail Address
Skip to end of metadata
Go to start of metadata

A PL/SQL function which seperates domain from email address

 

create or replace 
 function domain_from_emailaddress 
 (
 address in varchar2
 )
 return varchar2
 is
 domain varchar2(255);
 begin
 domain := substr(address,instr(address,'@'),length(address)-instr(address,'@')+1);
 return domain;
 end;