Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does somebody know a better way
Das Schaf <me_at_domain.com> wrote in message news:<MPG.1819f76f3cf348db989680_at_news.compaq.com>...
> I am trying to strip non-alphanumeric characters from a string - I have
> come up with a solution using the TRANSLATE function e.g.
I think that this is a classic example for external function especially using C language. You can't find quicker and in this particular case easier solution than this one. Use tool for purpose for which was designated, SQL is great for getting data, but leave character operation to C.
-- _________________________________________ Dusan Bolek, Ing. Oracle team leader Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we can call it an overture to bankruptcy) on that server. I'm still using this email to prevent SPAM. Maybe one day I will change it and have a proper mail even for news, but right now I can be reached by this email.Received on Fri Oct 18 2002 - 10:02:28 CDT