Skip to Main Content

APEX

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!

Display an alternate text instead of NULL

Nitin Kashyap20 hours ago

HI,
I have this IG with a UNIT_TYPE column of type select list.

the data for the LOV comes from an SQL query and data is

select unit_flag_label d, unit_flag_value as r from MTL_UNIT_FLAG

as u can see the return value for data entry in NULL.

How to i show data entry instead of NULL in the IG

(Note : IG is updatable)

I have tried this too

Any help is very much appreciated

Comments
Post Details
Added 20 hours ago
7 comments
76 views