Tag Archives: oracle

Smart Sync

Posted on March 22, 2021 by Giovanni Giorgi
On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian): SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I … Continue reading →
Posted in English Content, Gio's Software Projects | Tagged , , , | Comments Off on Smart Sync

Semplice metodo per storicizzare i dati su database

Posted on March 17, 2021 by Giovanni Giorgi
Abstract: Storicizzare i dati spesso è un attività considerata “secondaria”, ma un cattivo design porta a base dati difficili da ottimizzare e spesso poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è … Continue reading →
Posted in Italian Content, Structured Query Language (SQL) | Tagged , | Comments Off on Semplice metodo per storicizzare i dati su database

SQLite Oracle Compatibility Layer

Posted on August 7, 2018 by Giovanni Giorgi
  It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did Github link: https://gitlab.com/daitangio/sqlite_ora_functions
Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) | Tagged , , | Comments Off on SQLite Oracle Compatibility Layer

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Posted on June 16, 2017 by Giovanni Giorgi
Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL … Continue reading →
Posted in English Content, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , , , , | Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite

Italian Accent Oracle fix

Posted on February 10, 2017 by Giovanni Giorgi
In Italian language we have accent words like àèéìòù They are quite important because for instance “is” is spelled è whereas “and” is spelled e Accent are bad guys even today: if you copy them from MS-Word inside an Oracle … Continue reading →
Posted in English Content, Structured Query Language (SQL) | Tagged , | Comments Off on Italian Accent Oracle fix

Oracle SQL Developer Keep Alive plugin

Posted on January 26, 2017 by Giovanni Giorgi
On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I have found a small plugin for Sql Developer to solve this issue: it is very handy and logs its usage. Code is also … Continue reading →
Posted in English Content, Gio's Software Projects, Knowledgebase, Software, Structured Query Language (SQL) | Tagged , , , | Comments Off on Oracle SQL Developer Keep Alive plugin

Oracle Auto increment trigger HOWTO

Posted on December 14, 2016 by Giovanni Giorgi
Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now. Even if  Oracle databases (<12) does not support auto increment, you can easily ask to your … Continue reading →
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , | Comments Off on Oracle Auto increment trigger HOWTO