Tag: Oracle APEX

Happy Birthday, Translate APEX!

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

Posted in business, news, tech Tagged with: , , , , , , , ,

Pretius APEX Nested Reports Plugin with Bootstrap popover

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

Posted in tech Tagged with: , , , , , ,

APEX Connect 2016 – short summary

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

Posted in news, tech Tagged with: , , , , ,

Pretius Oracle APEX Team – summary of 2015

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

Posted in business, news, tech Tagged with: , , , , , , , , ,

How to create checkbox in report in Oracle Apex 5.0 – quick tip

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:

Is it

Posted in tech Tagged with: , , , , , , , , ,

Spicy spaghetti or how to avoid spaghetti code

– 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

Posted in tech Tagged with: , , , , , , , , ,

How to fix broken static files in Oracle APEX?

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

Posted in tech Tagged with: , , , , , , , ,

How to create report from XLSX file in Oracle APEX?

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

Posted in tech Tagged with: , , , , , , , , , , , ,

How to print PDF reports from PL/SQL code in few simple steps?

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

Posted in tech Tagged with: , , , , , , , , , , , ,

#IMAGE_PREFIX# vs /i – which to choose for static files URL building in Oracle APEX?

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

Posted in tech Tagged with: , , , , , , , , ,

Hire us!

Pretius is a software development company.
We create web applications using: Java, Oracle DB, Oracle Apex, AngularJS.
Contact us to talk about how we can help you with your software project!