I don't believe there are any equivalent PL/SQL functions, unless you write your own. PL/SQL won't be able to compete with Oracle Media ( is that its name this month?) in terms of performance. Jared "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 05/05/2004 07:11 AM Please respond to oracle-l To: <oracle-l@xxxxxxxxxxxxx> cc: Subject: CONTAINS,CATSEARCH, andMATCHES are more effective than plsql equivalent? Hi If you have installed Oracle text you can use other functions like CONTAINS,CATSEARCH, andMATCHES My question is if someone knows about some performance test that shows Oracle text functions as better than plsql equivalent functions. Thanks Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------