Home » SQL & PL/SQL » SQL & PL/SQL » Getting The Mail Id (9i)
Getting The Mail Id [message #355511] Fri, 24 October 2008 10:13 Go to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi All,

I want to get the mail id from the following string:

v_id:=raja@yahoo.com;

The output should be only

raja@yahoo.com

Thanks,
Kumar
Re: Getting The Mail Id [message #355518 is a reply to message #355511] Fri, 24 October 2008 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide

Regards
Michel
Re: Getting The Mail Id [message #355588 is a reply to message #355511] Sat, 25 October 2008 16:08 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So that would be everything between the "=" and ";" characters; find their positions using the INSTR function. Use SUBSTR (along with previously mentioned INSTRs) in order to extract the desired value.
Previous Topic: Search the whole user
Next Topic: What update index does?
Goto Forum:
  


Current Time: Wed Dec 07 10:52:49 CST 2016

Total time taken to generate the page: 0.10584 seconds