Demo: https://apex.oracle.com/pls/apex/f?p=80981:3 For those of you who are in a long term migration of Forms applications to the Apex platform, this article might be of interest. Especially for developers who relied on Headstart Designer, which was a productivity booster for Oracle Designer, made by the Dutch Oracle Consultancy department.Part of the Headstart tool was the… Read More »

I used to write my free text search SQL in Apex Standard Reports or as a Pre-Filter for Interactive Reports or -Grids like this, based on a single text field :P1_SEARCH Demo see: https://apex.oracle.com/pls/apex/f?p=80981:2 select emp.empno, emp.ename, emp.job, mgr.ename manager, to_char(emp.hiredate,'YYYYMMDD') hiredate, emp.sal salary, emp.comm commision, dep.dname departmentfrom empjoin dept dep on dep.deptno = emp.deptnoleft… Read More »