kbdharun/custom-report-oracle-apex.md

Created September 16, 2024 04:13

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kbdharun/2ff128450ba01633aaae5c3e1deceb5c.js"></script>
Save kbdharun/2ff128450ba01633aaae5c3e1deceb5c to your computer and use it in GitHub Desktop.

Oracle Apex Query for Employee and department table for custom report using select list

Raw

Report:

select EmpNo, EName, Job, Sal
from EMP
where job = :P10_JOB
and :P10_deptname=(select dname from dept where dname= :P10_DEPTNAME)
order by EName;

Page Items (Select List):

select distinct Job as DisplayVal, Job as ResultVal
from EMP
order by DisplayVal;

Select an option