Exactly one year ago, on 30.11.2015, we launched Translate APEX Project – the website containing collection of free translations for Oracle Application Express. Oracle APEX as a global tool: is available with Oracle DB all over the world, is used by developers and companies…
One month ago I have released new Oracle APEX plugin Pretius APEX Nested reports which has been greeted with enthusiasm among APEX developers. Since then, I have been asked how to implement Bootstrap popover functionality as Custom Callback. In this article…
Once again our Oracle APEX Team took part in APEX Connect conference. This time around APEX Connect 2016 took place in Berlin, Germany. This year’s conference lasted longer than previous editions (3 days). Thanks to this we experienced two whole days dedicated strictly…
Without a doubt 2015 was a great year for Oracle APEX community in the world, what was summarized by Joel Kallman on the official Oracle blog. We are very proud that Pretius Team was a part of this by participating in many projects and…
For new projects implemented with Oracle Application Express we are happily using Apex 5. One of the first questions was “how to create checkbox column in report?” After reading Oracle Apex documentation we came up with this select statement:
|
1 2 3 4 |
SELECT APEX_ITEM.CHECKBOX2(1,empno) "Select", ename, job FROM emp ORDER BY 1 |
Is it…
– You can’t name a function “udpate_counters ” which does something else. The name should describe program’s functionality. The program increases a counter, that’s great, but apart from that it does also DELETE. Which has nothing to do with these…
Working on development of the existing Oracle APEX applications many times I met a problem of Static Files that can not be refreshed. This manifested itself as follows: after deleting old version of a file (ex. javascript library) and uploading new one…
In many companies XLSX files (file format that is created by MS Excel 2003+) are used as a standard report data carrier. In some cases this files even replaces simple tables in databases. But almost always there comes a time when…
In every business application created in any technology, users need to create some reports (e.g. results of some researches, letters, notes, invoices, etc.), which may be saved on hard drive. Due to the existing needs, Oracle developer community has created a free-to-use…
Recently one of our customers asked me why I use #IMAGE_PREFIX# substitution string instead of /i/ in my Oracle APEX application when I refer to server located files (Tomcat in this example). The reason is quite simple – it’s not…
