SQLite Oracle Compatibility Layer
It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and…
Tag: oracle
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…
Oracle Auto increment trigger HOWTO
Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I…
Oracle Database Sync
Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I…
ORA-01461: can bind a LONG value only for insert into a LONG column
Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous…
Debian perfect work environment
Working in a big company, my work laptop came with MS-Windows7 Enterprise installed. But as you imagine, Unix…
Oracle Invalid number ORA-01722
I stumbled upon a very brain-f**k error on Oracle 10g on these days. Context: the following query [sql]SELECT…
Twitter il gradasso
C’è una cosa fantastica di Internet: se qualsiasi società prova a fare la furba, inserendo delle righe scritte…
Windows x64: 32bit Odbc vs 64bit Odbc
I run into a very big trouble on these days. My big company delivered to me a Windows7…
Shopping in the IT
Oracle buys BEA and Sun buys MySql.
In reply,Migrosoft is hungry and is watching Yahoo :-)
Let's play a bit with these ideas :)
oracle mass table drop
Sometimes I need to build a small script to delete a huge set of tables of a schema.…