Re: Performance of REGEXP_LIKE vs LIKE?

Hello.

You write that "Regular expressions are implemented using Java. You force Oracle to call Java, an interpreted language. The delay would be caused by the architecture."

I don't think this is always correct. I am using Oracle XE at home and it doesn't install Java and you can't write Java stored procedures. You can still use the "regexp_like" function however. I think therefore that in Oracle XE the regular expressions are not written in Java. Someone else can confirm this is the same in Enterprise and Standard Oracle versions.

Please correct me if I am wrong - I am still learning Oracle.

Thank you
John Received on Thu Apr 19 2007 - 06:40:15 CDT