RE: [suse-oracle] SIMILAR TO

From: Berger, Martin (martin.berger@upc.at)
Date: Tue Oct 01 2002 - 08:19:52 CEST

  • Next message: Paxton, Michael: "RE: [suse-oracle] SIMILAR TO" 
    Message-ID: <560CCBE8BFA6D611B05400D0B77E66D382C2D6@tele-mail.telekabel.co.at>
From: "Berger, Martin" <martin.berger@upc.at>
Date: Tue, 1 Oct 2002 08:19:52 +0200 
Subject: RE: [suse-oracle] SIMILAR TO

    Hi,

    There is no native regexp support in Oracle RDBMS.
    But there are at least 2 possible ways:
      create an external procedure which provides the regexp-functionality
        and a small PL/SQL package with the apropriate function.
    Or
      create a java class with all required functionality.

    There are no precreated packages but some (more or less) working examples
    available from Oracle Metalink.

    Kind regards,
     Martin

    > -----Original Message-----
    > From: snpe [mailto:snpe@snpe.co.yu]
    > Sent: Monday, September 30, 2002 6:07 PM
    > To: suse-oracle
    > Subject: Re: [suse-oracle] SIMILAR TO
    >
    >
    > Like is not this.
    > SIMILAR TO have complete regular expression syntax, LIKE is
    > only part . regards haris peco On Sunday 29 September 2002
    > 07:11 pm, Alan R. Williams wrote:
    > > See LIKE
    > >
    > > -----Original Message-----
    > > From: snpe [mailto:snpe@snpe.co.yu]
    > > Sent: Sunday, September 29, 2002 8:59 AM
    > > To: suse-oracle
    > > Subject: [suse-oracle] SIMILAR TO
    > >
    > >
    > > Hello,
    > > There is in Oracle RDBMS any support for SIMILAR TO or regular
    > > expression
    > >
    > > regards
    > > haris peco
    > >
    > >
    > ---------------------------------------------------------------------
    > > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see
    > > http://www.suse.com/oracle/ before posting
    >
    >
    > ---------------------------------------------------------------------
    > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see http://www.suse.com/oracle/ before posting
    >

    This archive was generated by hypermail 2.1.4 : Tue Oct 01 2002 - 08:20:50 CEST