Category Archives: 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

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

Oracle Database Sync

Posted on November 23, 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. I will show here a very fast way of comparing different database and auto-generate migration script. … Continue reading →
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , , | Comments Off on Oracle Database Sync

Oracle Invalid number ORA-01722

Posted on July 16, 2013 by Giovanni Giorgi
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT * FROM ( SELECT TO_NUMBER(CUSTOMER_ID) AS SNDG FROM BAD_CODES_TABLE WHERE AND I_LIKE=UPPER(‘STATIC_CONDITION’) AND CUSTOMER_ID NOT LIKE ‘%P%’ ) S WHERE TO_NUMBER(S.SNDG) >2000[/sql] … Continue reading →
Posted in English Content, Knowledgebase, Structured Query Language (SQL) | Tagged , , , , | Comments Off on Oracle Invalid number ORA-01722

Come evitare iniezioni SQL lato DB in SQLServer, Oracle, MySQL

Posted on December 3, 2012 by Giovanni Giorgi
 Come evitare iniezione SQL: lato SQL Server (SP_EXECUTESQL) In generale va evitato nel modo più assoluto la scrittura di query sql diamiche. Va evitato cioè  l’uso lato SQL Server di sp_executesql e EXEC Di seguito mostriamo come trasformare una query … Continue reading →
Posted in Italian Content, Structured Query Language (SQL) | Tagged , , , , , , , , | Comments Off on Come evitare iniezioni SQL lato DB in SQLServer, Oracle, MySQL