In the bygone era of database management, sluggish SQL queries often led to suspicions directed at indexes. Manual creation, deletion, and rebuilding of indexes were labor-intensive tasks, even with the assistance of scripts. However, these generic index treatments applied to diverse databases were neither precise nor efficient. Considering the distinct Read more…
Recently, I found myself confronted with the challenge of presenting detailed information about receivable invoices from a company. A crucial requirement was displaying the salesperson and department linked to the original sale. However, the complexity arose from multiple invoices grouping distinct sales for different salespeople and departments. To meet the Read more…
Introduction: Recently, I found myself tasked with analyzing an application that was causing an excessive number of redundant records to be stored in the database. The issue stemmed from the fact that certain pieces of information, which ideally should have been updated, were instead generating entirely new records. In this Read more…
In recent database management tasks, I encountered the need to extract an “attendant” ID from a JSON document stored in a CLOB column within the table df_nsf_mov_det. This information was crucial for storing the value in another table. The challenge lay in the fact that the “response” field contained a Read more…