Tag: oracle database

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

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

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

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 …

How to fix broken static files in Oracle APEX? 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: , , , , , , ,

Hard-coding – common sense definition Hard-coding appears in our software when we (programmers) write inflexible code with special “magic” values that are meaningful to original coder when written, but when times goes by no one knows what they stand for.  In effect we got code …

How to avoid hard-coding in your PL/SQL code? Read More »

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

If you develop your APEX applications in language other than used in APEX interface (English, German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese and Traditional Chinese), you have probably faced problem of translation some Oracle Application Express built-in strings …

Translating Oracle APEX messages – it’s easy! 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!