Tag: pl/sql

Oracle APEX – Let’s integrate with JIRA! Part 3

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

Tagged with: , , , ,

Oracle APEX – Let’s integrate with JIRA! Part 2

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

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

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 create report from XLSX file in Oracle APEX?

In many companies XLSX files (file format that is created by MS Excel 2003+) are used as a standard report data carrier. In some cases this files even replaces simple tables in databases. But almost always there comes a time when

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

How to print PDF reports from PL/SQL code in few simple steps?

In every business application created in any technology, users need to create some reports (e.g. results of some researches, letters, notes, invoices, etc.), which may be saved on hard drive. Due to the existing needs, Oracle developer community has created a free-to-use

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!