Oracle Text (MOSC)

MOSC Banner

How to include only "active" rows in the Oracle Text index.

edited May 23, 2019 5:02AM in Oracle Text (MOSC) 1 commentAnswered

Is it possible to avoid certain rows to be included in the index? The issue is that the indexed table has from- and to-date field for history reasons. Only rows where sysdate is between from- and to-date or to-date is null should be considered as "active" and hence subject for indexing. Also, when a row gets a to-date less than sysdate, it should be removed from the index.. Not sure how to solve this.... But thanks :-)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center