Tag: oracle

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

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 …

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

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

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

Advanced faceted search in SQL database using MyBatis Read More »

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

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 …

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

During your software projects you must have come across an issue which includes bulk operations on relational database (mass updates, inserts, deletes). As it occurs, performing single statements for bulk operations is lengthy due to the fact that each database action involves using (setting …

How to use MyBatis to effectively perform batch database operations? 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!