Static LOV’s can contain any characters

Yesterday i stumbled (for the umpteenth time) over the static LOV limitations in Oracle APEX. I tried to have a comma (“,”) in the Return Value which messed up my LOV, because a comma is a seperation character in the LOV definition.

Luckily Patrick blogged about this a few years back and i want to bring this to attention again.

By Default static LOVs use “,” and “;” as seperation characters between Lov Display Value and Lov Return Value (and the next Lov Display Value…).



Now if you want to use “;” or “,” as Display or Return Value, you can tell the Static-LOV to use other seperation characters

STATIC2(~,*):No Work, Holiday*FREE~Working Day*DEFAULT

This might not sound to glorious now, but when you need it you’ll be grateful ;-)

2 thoughts on “Static LOV’s can contain any characters

Leave a Reply

Your email address will not be published. Required fields are marked *