select distinct work_country d, work_country r from wwv_demo_emp order by 1

select distinct work_city d, work_city r from wwv_demo_emp where work_country = :P7_WORK_COUNTRY order by 1

select dname, deptno from wwv_demo_dept order by 1