Home » SQL & PL/SQL » SQL & PL/SQL » How to find a specific special characters from a string (merged 3)
How to find a specific special characters from a string (merged 3) [message #382820] Sun, 25 January 2009 06:16 Go to next message
fazalmca
Messages: 6
Registered: March 2006
Location: u.a.e
Junior Member
Hi,
I ve the email id field.
I ve to find the email id which have the set of special characters except @ and .
Ex.)
johnD'Souza@gmail.com
stephen@gmail.com
althaf~anwar@gmail.com
In the above 3 Email Ids i ve to found 1st one and 3r one through query,because it have special characters ' .

Please assist.

Regards,
Faz
Re: How to find a specific special characters from a string (merged 3) [message #382827 is a reply to message #382820] Sun, 25 January 2009 07:57 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In the above 3 Email Ids i ve to found 1st one and 3r one through query,because it have special characters ' .

ALWAYS post what you tried.

A simple search on "mail" help to find the following topic in 15 seconds:
http://www.orafaq.com/forum/m/324836/102589/?#msg_324836
ALWAYS search before posting.

Please read OraFAQ Forum Guide.
And don't multipost your question.

Regards
Michel

[Updated on: Sun, 25 January 2009 07:59]

Report message to a moderator

Previous Topic: PLS-00049: bad bind variable (merged)
Next Topic: Writing Quiry (merged)
Goto Forum:
  


Current Time: Sat Dec 03 18:23:30 CST 2016

Total time taken to generate the page: 0.15157 seconds