Re: NULL Values

From: Svend Jensen <svend.jensen_at_it.dk>
Date: Mon, 27 Jan 2003 20:35:00 +0100
Message-ID: <3E3589E4.7020609_at_it.dk>


You might try with a function based index, created to fit your needs. Under the right conditions, they work great wonders. /Svend Jensen

beutler wrote:
> I've problems retrieving a table where the key fields may contain NULL
> VALUES. The first problem is, that Oracle does not seem to distinguish
> between NULL VALUES, Empty Strings or even blank strings (which are
> trimmed to NULL). Isn't there any way to change this behaviour ?
> I want to retrieve the data in logical order, that means for me empty
> fields first. Because Oracle trims empty strings or strings of blanks
> to NULL and by default, returns NULLs last, I tried to use the NULLS
> FIRST clause in my query. But this is very slow, it seams Oracle will
> then no longer use the index if the query constraints via the index
> fields...
> Isn't there any way to retrieve data with empty values first while
> reading using an index ?
Received on Mon Jan 27 2003 - 20:35:00 CET

Original text of this message