CODEWITHSUNDEEP
listplsqloracle-apexlov
Sonny Boy
Sonny Boy

Reputation: 8016

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

Upvotes: 4

Views: 10566

Answers (3)

Juno
Juno

Reputation: 11

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

SELECT dname d, deptno r
   FROM dept

Upvotes: 1

Tony Andrews
Tony Andrews

Reputation: 132750

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;

Upvotes: 3

Vincent Malgrat
Vincent Malgrat

Reputation: 67802

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.

Upvotes: 0

Related Questions