Re: Q: How to do MATCHES with LIKE, etc

    In OWS ( ORACLE Web Server ) there is REGEXP package,     which is much more flexible than that (it's PERL regexp     sub(set) ), so you might want to get OWS 2.x or 3.x     and install relevant package(s) on your system , it's     worth it.

    There is some overhead, I'm not sure if you'll be able to     use it in SQL stmts, but still :)

    Rashid.

Niles Ritter <ritter_at_earthlink.net> wrote:
: In Informix there is a nice regular-expression operator
: MATCHES, where you can say
 

: SELECT * FROM table_x WHERE table_x.colm MATCHES '*[A-K]*[0-9]'
 

: and it will find all rows which contain a letter from A to K, followed
: later by a digit. With SQL Server, the LIKE operator can be used
: for this with:
 

: SELECT * FROM table_x WHERE table_x.colm MATCHES '%[A-K]%[0-9]'
 

: but in ORACLE, only the percent and underscore are permissible
: meta-characters in LIKE. So, how does one get the same set of
: rows in ORACLE, using SUBSTRING's, BETWEEN, etc. ? What I'm looking
: for is a general way of doing MATCHES regular-expressions, and not an
: ad-hoc solution to this particular example, unless it is illustrative.
 

: --Niles Ritter
Received on Mon Aug 11 1997 - 00:00:00 CDT