| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> cross reference index
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
![]() |
![]() |