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
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
Hi All,

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


The output should be only


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: 64944
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide

Re: Getting The Mail Id [message #355588 is a reply to message #355511] Sat, 25 October 2008 16:08 Go to previous message
Messages: 21122
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: Thu Jun 22 20:58:43 CDT 2017

Total time taken to generate the page: 0.27198 seconds