Tag: sql

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

Apache Solr: How to efficiently index large amounts of data?

Apache Solr provides means to search through indexed resources extremely quickly. The indexing process itself, however, can take a lot of time. When one googles “solr indexing efficiency” or “solr efficient indexing” one can find a lot of information on RAM

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

Advanced faceted search in SQL database using MyBatis

Faceted search is popular technique used in online retailers. Users can search for product using multiple filters, called facets, narrowing result list in each step. In addition to that, filters can show number of products matching each facets for selected conditions.

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 can you stop worrying about table and view dependencies in PostgreSQL?

PostgreSQL database is very restrictive when it comes to modifying existing objects. Very often when you try to ALTER TABLE or REPLACE VIEW it tells you that you cannot do it, because there’s another object (typically a view or materialized

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!