Undocumented option for Static List of Values
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
In such a case you can use
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):Display Value[<display-return-sep>Return Value]For example:
<lov-entries-sep>Display Value[<display-return-sep>Return Value]
STATIC2(~,*):Cat, Dog*1~Nemo, Shark*2
Labels: Oracle APEX, tips
















0 Comments:
Post a Comment
<< Home