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

Frank van Bortel wrote:
> vkatekan_at_yahoo.com schreef:
>
> > 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
>
> escape_sc (Special Characters) and escape_url functions should be able
> to accomplish that

I learned about something new. The escape_sc and escape_url appear to be new 10g functions for manipulating hmtl within pl/sql code. You can find information on these features in the PL/SQL Packages and Types Reference.

For pre-10 you will have to roll your own code using instr, substr, replace, translate, trim, etc....

HTH -- Mark D Powell -- Received on Fri Aug 18 2006 - 08:45:42 CDT