Tag: oracle database

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

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

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

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

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

Translating Oracle APEX messages – it’s easy!

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

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!