Tag: Oracle APEX

POUG 2018 from Students’ Perspective

Oracle conferences are excellent opportunities to take part in inspirational lectures about database administration, programming and general trends in Oracle world. The Polish edition, called Pint with Oracle User Group (POUG), was located in Sopot this year. Surrounded by the scenery

Tagged with: , , ,

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

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

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

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

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

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

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

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

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

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!