Toad World® Forums

Oracle 11g Database Express Fuzzy Searching

Hello:

Very new to this forum. I’ve recently installed the above referenced software, but no clue how to use it. I use SQL daily, and would like to utilize Oracle functionality (specifically the TEXT features and FUZZY searching). I would then use TOAD for Oracle and SQL syntax to query the data.

Is there a link or post somewhere that shows me how to: a) load data; b) create necessary indexes; c) Link TOAD to db; d) Begin querying.

Thank you.

You could start with this white paper from Oracle Corporation: www.oracle.com/…/11goracletexttwp-133192.pdf. Page 19 has a simple example to get you started:

We would like to create a text index on the PRODUCT_DESCRIPTION column to make

it searchable. The index creation is a SQL statement:

CREATE INDEX description_idx ON
product_information(product_description)
INDEXTYPE IS CTXSYS.CONTEXT

Searching is also a SQL statement:

SELECT score(1), product_id, product_name
FROM product_information
WHERE CONTAINS
(product_description, 'monitor NEAR "high resolution"', 1)>0
ORDER BY score(1) DESC;

You can also refer to the Oracle Text Application Developer’s Guide: docs.oracle.com/…/toc.htm.

I hope this helps.

Thank you for the quick reply. I will read up on that.