Tammy - For a small amount of searching, take a look at function-based indexes (you just said usernames). - You can also create your own method with PL/SQL pretty easily. Strip individual words into a separate table that can be easily searched. - For heavy-duty searching, look at Oracle Text (interMedia Text in Oracle8i) http://technet.oracle.com/products/text/content.html - Don't use ColdFusion. It is easy but difficult to scale. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Wednesday, May 28, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Could someone give me some information or lead on how I can create a search engine for usernames. I am running an 8.1.7.4 database and also 9ias for my web application. I have received some info such as to create the code in ColdFusion and link up to the database with ODBC. Does anyone have any other possibility? Thanks, Tammy R. Jordan Morehouse College [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tammy Jordan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).