Re: [suse-oracle] SIMILAR TO

From: snpe (snpe@snpe.co.yu)
Date: Tue Oct 01 2002 - 16:37:15 CEST

  • Next message: Matthew Bull: "RE: [suse-oracle] persistant install gremlins suse 8.0 - oracle 9i-R2 FIX" 
    From: snpe <snpe@snpe.co.yu>
Date: Tue, 1 Oct 2002 16:37:15 +0200
Message-Id: <200210011637.15416.snpe@snpe.co.yu>
Subject: Re: [suse-oracle] SIMILAR TO

    That is not solution, because indexes, btw.
    SIMILAR TO is sql99 (maybe sql92) standard
    regards

    On Tuesday 01 October 2002 08:19 am, Berger, Martin wrote:
    > 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

    ---------------------------------------------------------------------
    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 - 16:14:09 CEST