Search code examples
listplsqloracle-apexlov

Conditional Lists of Values in Oracle APEX?

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...

Solution

  • 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;