Hi everyone ,
My page has the interactive grid , the button for submit and select list for search department
my logic is
1. Select list is null , Column department show all
-
Option selected , Interactive grid show department selected
-
Value on Column department is default from Select list
SQL Query on Column department :
select dname d , deptno r from dept
and default property :
but when i gonna insert department value . it should display department Name (dname) . not deptno
Do you have any Idea ?
Demo:
https://apex.oracle.com/pls/apex/f?p=18071:6