>>I have a view that was created with left outer join. As a result that cursor contains NULL values.
>>
>>Now I want to index that view to use in a grid in a form. The problem is that I can't create the index with NULL.
>>
>>How can I solve this problem?
>
>Forget about that I found what was needed.
NVL function, I guess :) BTW, I had a similar thread about two months ago.
If it's not broken, fix it until it is.
My Blog