Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating an Oracle Text index on multiple columns from 3 different tables

Kevin_KSep 6 2005 — edited Sep 8 2005

I need to create an index on 3 tables:

Table A
col1
col2
col3

Table B
col1
col2
col3

TABLE C
col1
col2

This index should get the values if any matching word is found in either of the 3 tables.

For example

If I do a search for col1 = 'ALEX' the query should look for the records from all the 3 tables which have anything similar to 'ALEX in either of the 3 tables in any of the columns.

Can someone please suggest me how to implement this ?

Thanks

Kevin

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2005

Added on Sep 6 2005

#database-key-features, #text

7 comments

2,188 views