Skip to Main Content

Oracle Database Discussions

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!

Indexes with NULL values

445540Dec 31 2005 — edited Sep 13 2007
Hello.

I am developing an application for my company. The application was implemented in Microsoft Access and I need to use a specific type of Access index that ignores rows where any of the indexed columns are null. For Oracle each of these rows are included in the index while Access simply ignores them.

Is there any way to tell Oracle to ignore such rows....... I mean: Avoid indexing a row where any of the indexed columns are null.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2007
Added on Dec 31 2005
7 comments
8,116 views