Category: Structured Query Language (SQL)
Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data
SQLite Oracle Compatibility Layer
It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions,…
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…
Italian Accent Oracle fix
In Italian language we have accent words like àèéìòù They are quite important because for instance “is” is…
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…