How to add ALL option to Discoverer LOV.

This document wrote by me after that I checked Metalink Note:182068.1 .

Create New Custom Folder base on union:
select ename from emp
union
select 'ALL' from dual;

Edit your item class for Ename so that it uses the value in this folder to
create the list of values.

Create a parameter in Discoverer Desktop Edition (client/server) for Ename and
an associated condition like this:

ename LIKE DECODE(:P_ENAME,'ALL','%',:P_ENAME)