Plsql Query Doubt

[nikhilboorla]

plsql query to get domain name from email id using functions

 

i need to display gmail.com from [email protected]

and i want to display all types of email domains like gmail,yahoo,in,hotmail in order

 

 

[mettastar]

Substr(email,instr(email,"@"))
E function apply cheyi

[Tonic]

Substr(email,instr(email,"@"))
E function apply cheyi

 

Bro every user email ki different length vutundi kada..Does it works??

[LungiLingaraju]

Bro every user email ki different length vutundi kada..Does it works??

it will work instr ante first occurrence nundi istundi ... Length asal consider cheyaledu paina

[LungiLingaraju]

Bro every user email ki different length vutundi kada..Does it works??

email ani undi kada dani place lo neeku kavalsina email id ivvu ..

[mettastar]

Bro every user email ki different length vutundi kada..Does it works??

It works bro.. first INSTR ane function '@' symbol position kanukuntadhi... SUBSTR '@' position daggara nunchi migithadi substring chesthundhi...

[LungiLingaraju]

It works bro.. first INSTR ane function '@' symbol position kanukuntadhi... SUBSTR '@' position daggara nunchi migithadi substring chesthundhi...

repost .. Nenu kuda ade cheppina

[mettastar]

repost .. Nenu kuda ade cheppina

[upendra_super]

vesina ventane answer vachesindhi ga sHa_clap4  sHa_clap4 afdb rocks  

[nikhilboorla]

thanks.....