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: 65155
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: 21151
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: Order by clause difference
Next Topic: Search the whole user
Goto Forum:
  


Current Time: Thu Aug 24 00:07:48 CDT 2017

Total time taken to generate the page: 0.01550 seconds