Oracle |

Italian Accent Oracle fix

Feb 10, 2017 · 1 min read en sql · oracle relax ·

Share on:

In Italian language we have accent words like àèéìòù

They are quite important because for instance "is" is spelled

è

whereas "and" is …

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Jun 15, 2017 · 1 min read en knowledgebase sql · evil oracle postgresql sql ·

Share on:

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" …
Read More

SQLite Oracle Compatibility Layer

Aug 7, 2018 · 1 min read en software-projects projects python sql · oracle sql sqlite ·

Share on:

The Sqlite Oracle Compatibility Functions is an experimental compatibility layer for SQLite vs Oracle, written in Python 3.

It aims to provide a …

Semplice metodo per storicizzare i dati su database

Mar 16, 2021 · 6 min read it sql · database oracle ·

Share on:

Abstract: Storicizzare i dati spesso è un attività considerata "secondaria", ma un cattivo design porta a base dati difficili da ottimizzare e spesso …
Read More

Smart Sync

Mar 21, 2021 · 1 min read en software-projects · database oracle sqlite ·

Share on:

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 …