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

Home -> Community -> Usenet -> c.d.o.server -> Re: Does somebody know a better way

Re: Does somebody know a better way

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 18 Oct 2002 08:02:28 -0700
Message-ID: <1e8276d6.0210180702.5bc23e8e@posting.google.com>


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

Original text of this message

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