Search code examples
sqloraclenulloracle-apexlov

Refer to NULL in List of Values (Oracle APEX)

So I have a List of Values, and I want to have a display value of "Yes" when the return value is NULL. I tried leaving the return value blank, and even writing null, but when I go to my table and use the LOV, instead of getting my return value "Yes", I still get

 -

Is there a proper way to refer to NULL in a list of values return value? Thanks.

Solution

  • Where are you seeing the dash? In a report showing the information? If so, reports default nulls to dashes - see 'report attributes' -> 'show null values as'.

    Otherwise, you may need to post what you're using for your LOV. And/or maybe an image of what you're seeing.