Tag Archives: oracle

Smart Sync

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

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

  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

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

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

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

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