Articles Related
Type
Static
Syntax:
STATIC:DisplayValue1[;ReturnValue1],DisplayValue2[;ReturnValue2],...
Example:
- Four Values Displayed in Alphabetical Order
STATIC:Cow,Dog,Cat,Lion
- A List of Values that return the Display Value
STATIC2:10,15,20,25,50,100,200,500,1000,10000
- A List of Values with Having Both a Return and Display Value
STATIC:Yes;Y,No;N
Cascade
- Create a first “Select List” item and name it P1_FIRST:
- Create a second “Select List” item named P1_SECOND:
- From Cascading LOV Parent Item(s) - Select P1_FIRST.
- In the LOV definition, use a bind variable that refers to the first item
SELECT name
FROM table
WHERE first = :P1_first
ORDER BY name