substr in oracle

[Vallaru smitha]

Hi,

[e-mail]

Can anyone please help to extract yahoo from above string.

Thanks

[Fatih Keles]

You can use a combination of substr and instr. Something like this.
select substr('[e-mail]',instr('[e-mail]','@')+1,instr('[e-mail]','.')-instr('[e-mail]','@')-1) from dual
But you may need to improve to handle repeating '.'

[Christophe Verré]

Note that Oracle supports regular expressions (REGEXP_LIKE), so if you can come up with a regular expression to extract that part, you'll probably be able to use it with Oracle.