DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

NULL Values in Report Parameters

444825May 31 2005 — edited Jun 1 2005

All the reports in my application have one or more parameters. Most of the parameters have List of Values (LOV), with the data getting populated from a backend table. The user has a flexibility to either select a particular value from the list or leave it which means it can be null. So along with all the values from the table there must be one more blank entry which means it is NULL. I am not able to get this entry in the LOV. I tried specifying the query in the following way:
--------------------------------------------
select deptcd aa,deptname bb from department
union
select null,null from dual
--------------------------------------------
but it does not work. All the values except the null values gets populated. Can anybody suggest the solution for this.

Thanks in advance
Ramanan