Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> cross reference index

cross reference index

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 30 Nov 2000 17:32:17 GMT
Message-ID: <9062v1$h0c@dispatch.concentric.net>

We have a legacy database application that is being moved to Oracle. In the legacy application we had a cross reference type of index. It would index on each word in a text field. This allowed us to search for records using operators on individual words. For instance, a field called COMPANY_NAME may contain the value 'ACME Freight & Trucking'. We could search for this record by 'SELECT COMPANY_NAME FROM COMPANY WHERE COMPANY_NAME.XREF='ACME' AND COMPANY_NAME.XREF LIKE 'Truck%'.

This feature was built into the database engine.

Is there any way to emulate this in Oracle?

--
Jim Poe ( jpoe_at_fulcrumit.com )
Received on Thu Nov 30 2000 - 11:32:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US