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, 4 months agolucianoimelo
Most Recent 2 years, 3 months agonoureldin
3 years agoNakhala
3 years, 10 months agousmanchaudhy
3 years, 11 months agoindiana113
3 years, 5 months agomatmar
4 years, 2 months agoMarko_1991
4 years, 3 months ago