Kyle is developing a page with an interactive report, called Employees, using this query:
SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO)
On the page, Kyle adds a select list, called P3_DEPTNO, using this query:
SELECT dname, deptno FROM dept;
He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.
Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.
What must Kyle do to correctly display only employees from the department selected?
sbrand
Highly Voted 4 years, 2 months agolucianoimelo
Most Recent 2 years, 1 month agonoureldin
2 years, 10 months agoNakhala
3 years, 8 months agousmanchaudhy
3 years, 9 months agoindiana113
3 years, 3 months agomatmar
4 years agoMarko_1991
4 years, 1 month ago