Sql |

SQL: One of the most valuable skills - Craig Kerstiens

Feb 19, 2019 · 2 min read
en sql · postgresql sql sqlite
·
Share on:

I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa).

Read More
Outer full and inner SQL joins: you are wellcome

Aug 27, 2018 · 1 min read
en sql · sql
·
Share on:

For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins

All the Join you want
SQLite Oracle Compatibility Layer

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

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

Read More
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” which can be used to indentify a column in a unique way. On PostgreSQL is called ctid, as we shall see:

Read More
Italian Accent Oracle fix

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

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

Read More
- 1
- 2
- 3
- 4
- 5