Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to check for special charcters in an email address using plsql code?

How to check for special charcters in an email address using plsql code?

From: <vkatekan_at_yahoo.com>
Date: 17 Aug 2006 19:18:50 -0700
Message-ID: <1155867530.123024.284240@b28g2000cwb.googlegroups.com> 





Hi There,


I am trying to write a plsql function to filter an email address which
has a special address in it.  I tried to filter them out by creating a
table for bad charcters (i.e Chr(0...31 & 127...255), but this is also
filtering out an email address with '_'  charcter and just wondering
how can I accomplish this one.



Thank you very much in advance for all your inputs.



Regards,


Rao
Received on Thu Aug 17 2006 - 21:18:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US