Oracle |

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):

Read More
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 poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è facile da capire ed è attivamente usato in produzione.

Read More
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
Oracle Auto increment trigger HOWTO

Dec 13, 2016 · 1 min read
en featured knowledgebase sql · oracle tip
·
Share on:

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 sql data modeler to generate for you a sequence and a trigger in a automatic way.

Read More
Oracle Database Sync

Nov 22, 2016 · 1 min read
en featured knowledgebase sql · oracle tip
·
Share on:

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.

Read More
ORA-01461: can bind a LONG value only for insert into a LONG column

Sep 1, 2015 · 1 min read
en knowledgebase · bad oracle relax sql
·
Share on:

Disapprove with me!

Okey, you know Oracle. A very good database, a very old database, a very solid rock. Not famous for its error messages. I have already stumbled upon a misleading error on the old rock.

Read More
Debian perfect work environment

Sep 28, 2014 · 3 min read
en featured software unix-featured · ibm linux oracle unix virtualization
·
Share on:

Working in a big company, my work laptop came with MS-Windows7 Enterprise installed. But as you imagine, Unix is my preferred desktop environment. So let’s how to configure a perfect Debian Linux for a old wolf consultant like me. You will be able to install commercial software mubmo jumbo like Oracle Express and IBM Websphere in a snap, and have a 64 rock solid system, easy to bring in a USB stick if you like.

Read More
Oracle Invalid number ORA-01722

Jul 15, 2013 · 1 min read
en knowledgebase sql · bad bug oracle sql
·
Share on:
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] could trigger a Invalid number if CUSTOMER_ID column contains invalid numbers.

Why?

Well…if you ask to “explain plan”, you will get something like
- a table full scan
  
  Filter Predicates AND
  
  I_LIKE=UPPER('STATIC_CONDITION')
  
  TO_NUMBER(S.SNDG) >2000
  
  CUSTOMER_ID NOT LIKE '%P%'
Read More
Twitter il gradasso

Aug 25, 2012 · 2 min read
it · api avvocato-del-diavolo development freedom mysql oracle
·
Share on:

C’è una cosa fantastica di Internet: se qualsiasi società prova a fare la furba, inserendo delle righe scritte in piccolo quando revisiona la sua API da 1.0 a 1.1, state certi che ci sarà almeno una persona che si leggerà tutto, troverà la fregatura e sputtanerà la summenzionata società.

E’ quello che è successo con Twitter, e Marco Arment analizza nei dettagli le “novità” della nuova Twitter API che passa dalla versione 1.0 alla 1.1.

Vi rimando all’articolo per i dettagli, ma in buona sostanza Twitter sta cercando di fare in modo che “se voi fate qualcosa di interessante con Twitter, bhe ora dovete collaborare con noi…per continuare a farlo….”:

Read More
Windows x64: 32bit Odbc vs 64bit Odbc

Nov 10, 2011 · 1 min read
en knowledgebase · database oracle
·
Share on:

I run into a very big trouble on these days.

Read More
Shopping in the IT

Jan 21, 2008 · 2 min read
blog-objectsrootcom en software · ant apple arc database db engine file good google hard make microsoft mysql news opinion oracle ping search search-engine sql ui war web
·
Share on:

Oracle buys BEA and Sun buys MySql.
In reply,Migrosoft is hungry and is watching Yahoo :-)

Read More
oracle mass table drop

Jul 3, 2007 · 1 min read
blog-objectsrootcom en · build easy oracle postgresql script small sql table ui vi
·
Share on:

Sometimes I need to build a small script to delete a huge set of tables of a schema.

Read More

Why?