Tag: oracle

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: , , , , , ,

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: , , , , , , , , ,

Oracle Best Practices – win with compelxity – naming standards

Standards – annoying warrant or useful tool? Poorly prepared standards which don’t  provide anything positive  in the software development process can annoy. Programmers instead of focusing on creative programming – are concentrating on following The Standard, which is often written on several

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: , , , , , , , , ,

Oracle: COUNT(*) vs COUNT(1) – the final battle

After the article “Count(1) or count(*) that is the question” I was asked about the proof that Oracle internally rewrites Count(1) into Count(*). Follow below steps and check for yourself 🙂 1. Create CNT_TEST table

2. Start TRACE 10053

3. Run query

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: , , , , , , , ,

Oracle: Count(*) or Count(1) that is the question.

Count(*) or Count(1) that is the question. For many years on Oracle’s forums there has been ideological fight: COUNT(*) or COUNT(1). Each option has its true believers and opponents. The most common argument of group which supports the use of

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!