Tag: pl/sql

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

ETL processes are key parts of Business Intelligence systems. Their creation involves many challenges that organizations must face if they want to base decision-making processes on real-time data analysis. And here, tools such as Pentaho Data Integration can help. In …

Oracle APEX – Let’s integrate with Pentaho! Part 2 Read More »

Tagged with: , , , , , , ,

ETL processes are key parts of Business Intelligence systems. Their creation involves many challenges that organizations must face if they want to base decision-making processes on real-time data analysis. And here, tools such as Pentaho Data Integration can help. It …

Oracle APEX – Let’s integrate with Pentaho! 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 3 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 2 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: , , , , , ,

– 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 …

Spicy spaghetti or how to avoid spaghetti code Read More »

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

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 …

Oracle: Count(*) or Count(1) that is the question. 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!