Hidden option for Static List of Values in APEX:
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 which is mentioned below
The online help documents the usage which is mentioned below
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]
<lov-entries-sep>Display Value[<display-return-sep>Return Value]
For example:
STATIC2(~,*):Cat, Dog*1~Nemo, Shark*2
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]
<lov-entries-sep>Display Value[<display-return-sep>Return Value]
For example:
STATIC2(~,*):Cat, Dog*1~Nemo, Shark*2
No comments:
Post a Comment