Conditional Lists of Values in Oracle APEX?

Question

I need to use the value of one Select List to populate the value of a second select list, but the items in Select List number two are going to be from a completely different tables depending on what's selected in list number one.

Is there a way I can conditionally populate the second list based on the values from the first? So far, my attempts to put an if statement into an LOV declaration have been unsuccessful...

score 3 · Accepted Answer · answered Oct 08 '09 at 12:28

3

The syntax to use an IF in an Apex LOV is like this:

IF :P123_CHOICE = 'EMP' THEN
  RETURN
  'SELECT ename d, empno r
   FROM emp';
ELSE
  RETURN
  'SELECT dname d, deptno r
   FROM dept';
END IF;

answered Oct 08 '09 at 12:28

Tony Andrews

129,880
21
220
259

score 1 · Answer 2 · edited Jun 18 '19 at 14:15

1

   SELECT ename d, empno r
   FROM emp
   WHERE :P123_CHOICE = 'EMP' 
UNION ALL

SELECT dname d, deptno r
   FROM dept

edited Jun 18 '19 at 14:15

double-beep

5,031
17
33
41

answered Jun 18 '19 at 14:14

Juno

11
1

score 0 · Answer 3 · answered Oct 08 '09 at 08:39

0

I don't know if this is applicable in your case but I have used some APEX_ITEM functions in the past to build dynamic objects. You could look into APEX_ITEM.select_list_from_query for example to create a select list dynamicaly.

answered Oct 08 '09 at 08:39

Vincent Malgrat

66,725
9
119
171

Conditional Lists of Values in Oracle APEX?

3 Answers3