Undocumented option for Static List of Values

27. April 2008

Oracle APEX, Tips & Tricks

Did you know that the STATIC and STATIC2 keyword used to define Static List of Values for Oracle Application Express (APEX) contains an undocumented option?

The online help documents the usage with 

STATIC[2]:Display Value[;Return Value],Display Value[;Return Value]

But what to do if one of your values contains the semi colon or the comma in the text? You will get a problem with the predefined separators!

In such a case you can use

STATIC[2](lov-entries-sep,display-return-sep) :D isplay Value[<display-return-sep>Return Value]
<lov-entries-sep>Display Value[<display-return-sep>Return Value]

For example: 

STATIC2(~,*):Cat, Dog*1~Nemo, Shark*2

2 Responses to “Undocumented option for Static List of Values”

  1. Scott K Says:
    July 10th, 2009 at 18:31

    This is really helpful! Thanks.

  2. Mohammad Makahleh Says:
    February 8th, 2010 at 17:19

    Thank you very much, it is very helpful post.

    But my problem that I am using APEX_ITEM.SELECT_LIST which takes a static list as parameter.

    You must pass this parameter without the ‘STATIC2′ keyword.
    I tried to add ‘(|,~)’ but did not work.

    Do you have any clue.

    Best Regards.

Leave a Reply