Oracle APEX in the item set to popup LOV type, how to realize the VALUE from the table to obtain an optional VALUE and can edit to add a new VALUE
1, types of dictionary dictionary
VIDEO_CAT MOVIE
VIDEO_CAT TV
VIDEO_CAT VARIETY
VIDEO_CAT CARTOON
VIDEO_CAT comedy
DIET_CAT D1
DIET_CAT D2
DIET_CAT D3
DIET_CAT D4
The above two columns, set the dictionary types to editable popup LOV type, optional value of the type of chart data already in the dictionary, you can also add a dictionary type,
Question 1, dictionary types have repeat,

 select dictionary types value1, value2 dictionary values from the TAB 

query dictionary types and values, the duplicate values appear in the selection box, how to make duplicate values appear only once?
Question 2, how to set it to editable, to new dictionary types, namely in the Input Field to select Enterable, Show and Store the Return Value. The question arises, will be displayed after the popup LOV marquee select value1 value2. The desired result is to choose the value1, appear value1, data are shown in table value1. How to do?

CodePudding user response:

Used oracle APEX,
1, to repeat, can use a distinct, such as a select distinct column from a table
2, popup LOV this thing will form the key - the value of this key/value pair to populate the data, if it is, then you have the above SQL