Your query to populate the list is:
select distinct deptno from emp;
How about:
select distinct deptno from emp union select 0 from dual;
then in your after parameter form trigger, check for deptno of 0. If that is selected, remove the part of your where clause which restricts the output to a specific dept.




Reply With Quote