Child pages
  • Seperate Domain from EMail Address

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A PL/SQL function which seperates domain from email address

...

 

Code Block
languagesql
create or replace 
 function domain_from_emailaddress

(
address in varchar2
)
return varchar2
is
domain
 
 (
 address in varchar2
 )
 return varchar2
 is
 domain varchar2(255);


 begin


 domain := substr(address,instr(address,'@'),length(address)-instr(address,'@')+1);


 return domain;


 end;