Find out Name and Domain name in email column of table database

   Email Extract

We have find out Name  in email id  of table database. Find below query find name in email id.

Name of email id

select SUBSTR(email, 1, (INSTR(email, '@')-1)) as name from emails

Domain name of email id

select SUBSTR(email, INSTR(email, '@')+1) as name from emails