Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cascading LOVS - default values [APEX 5.0]

bakus123May 22 2017 — edited Jul 5 2017

Hi friends, I have two cascading LOVs. After changing value of my first LOV in second LOV appropriate values are populated.

lovs.PNG

First LOV:

name - P2_DEPTNO

select dname,

   deptno

from dept

order by 1;

Second LOV:

name - P2_EMPNO

select ename,

   empno

from emp

where deptno = :P2_DEPTNO;

cascading LOV parent - P2_DEPTNO

What should I add to set default value of second LOV (first row from query) after changing first LOV value?

Thanks a lot in advance

This post has been answered by ApExEngma on Jul 4 2017
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 1 2017
Added on May 22 2017
5 comments
782 views