Conditional value lists in Oracle APEX?

Question

I need to use the value of one Select List to populate the value of the second selection list, but the items in the Select List number two will be from completely different tables depending on what is selected in the number one list.

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

Answer 1

The syntax for using IF in Apex LOV is as follows:

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

Answer 2

I do not know if this is applicable in your case, but I used some APEX_ITEM functions in the past to create dynamic objects. You can look at APEX_ITEM.select_list_from_query , for example, to create a dynamic selection list.

Answer 3

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