Tag: oracle

When we are working on projects for our clients, we often face the problem of database schema migration. In the previous article, I answered the basic questions about the migration problem. I presented capabilities of the Gradle and Flyway tools …

Gradle, Flyway & Oracle APEX – a few words about migration. Part 2 Read More »

Tagged with: , , , , ,

When we are working on projects for our clients, we often face the problem of database schema migration. This is not a simple task. Each time we have to answer the same questions: In which script are the changes implemented …

Gradle, Flyway & Oracle APEX – a few words about migration. Part 1 Read More »

Tagged with: , , , ,

Jira is Atlassian’s software for error tracking and project management.  Users working with any APEX application often need to report an error regarding the application usage or data they work with. Instead of logging in to Jira, looking for a …

Oracle APEX – Let’s integrate with Jira! Part 1 Read More »

Tagged with: , , ,

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 …

POUG 2018 from Students’ Perspective Read More »

Tagged with: , , ,

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 …

Happy Birthday, Translate APEX! Read More »

Tagged with: , , , , , , , ,

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 …

Pretius APEX Nested Reports Plugin with Bootstrap popover Read More »

Tagged with: , , , , , ,

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 …

Pretius Oracle APEX Team – summary of 2015 Read More »

Tagged with: , , , , , , , , ,

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 …

Oracle Best Practices – win with compelxity – naming standards Read More »

Tagged with: , , , , , , , , ,

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 …

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

Tagged with: , , , , , , , , ,

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 …

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

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!