I've created a "Form on a SQL Query" using the example database and query example:
select e.empno, e.ename, e.job, e.hiredate, e.sal, d.dname
from emp e, dept d
where e.deptno = d.deptno
which works fine. But suppose I want to modify the query? Where can I find it? Or is the only thing you can do is to delete the form region (and corresponding items and buttons) and start all over again?
I am also having this problem. If the query can't be viewed or modified as a matter of design (why?), just let me know.
I can't find the answer in any of the APEX documentation I've looked at. And it took me forever to find this unanswered thread that's over a year old.