oracle – Gioorgi

Smart Sync

March 22, 2021 March 15, 2021 / English Content, Gio's Software Projects / database, mssqlserver, oracle, sqlite / Leave a Comment

On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian): SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I evolved it to be able to support a special use case called “dump to SQLite”. …

Smart Sync Read More »

Semplice metodo per storicizzare i dati su database

March 17, 2021 April 7, 2021 / Italian Content, Structured Query Language (SQL) / database, oracle / Leave a Comment

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. Autori: Ernesto Ghetti (idea), Giovanni Giorgi …

Semplice metodo per storicizzare i dati su database Read More »

SQLite Oracle Compatibility Layer

August 7, 2018 March 15, 2021 / English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) / oracle, sql, sqlite

It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did Github link: https://gitlab.com/daitangio/sqlite_ora_functions

Removing duplicate rows in PostgreSQL, Oracle and SQLite

June 16, 2017 November 28, 2019 / English Content, Knowledgebase, Structured Query Language (SQL) / dup, duplicate, duplicates, evil, oracle, postgresql, removal, sql

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: Oracle way: DELETE FROM your_table WHERE rowid not …

Removing duplicate rows in PostgreSQL, Oracle and SQLite Read More »

Italian Accent Oracle fix

February 10, 2017 February 21, 2019 / English Content, Structured Query Language (SQL) / oracle, relax

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 sql script you can end up with different UTF-8 values. Also the accent are likely …

Italian Accent Oracle fix Read More »

Oracle SQL Developer Keep Alive plugin

January 26, 2017 March 15, 2021 / English Content, Gio's Software Projects, Knowledgebase, Software, Structured Query Language (SQL) / oracle, plugin, sql, sqldeveloper

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 very clean https://github.com/scristalli/sql-developer-keepalive 20 forks. 120 stars. 3 open issues. Recent commits: Update README.md, GitHub …

Oracle SQL Developer Keep Alive plugin Read More »

Oracle Auto increment trigger HOWTO

December 14, 2016 February 21, 2019 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / auto, datamodeler, increment, oracle, tip

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 …

Oracle Auto increment trigger HOWTO Read More »

Oracle Database Sync

November 23, 2016 February 21, 2019 / English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) / oracle, synchronization, tip

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. Reverse engineer the source database using Oracle Data Modeler Now select the right arrow shown …

Oracle Database Sync Read More »

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

September 2, 2015 August 5, 2015 / English Content, Knowledgebase / bad, oracle, relax, sql

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. This error anyway is incredible. If you try to push a very long text in a varchar2, you can end up with …

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

Debian perfect work environment

September 29, 2014 November 15, 2018 / English Content, IT Featured, Software, Unix / ibm, it works on my machine, linux, oracle, unix, virtual box, virtualization

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 …

Debian perfect work environment Read More »

Oracle Invalid number ORA-01722

July 16, 2013 February 21, 2019 / English Content, Knowledgebase, Structured Query Language (SQL) / bad, bug, oracle, sql, to_number

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 …

Oracle Invalid number ORA-01722 Read More »

Twitter il gradasso

August 25, 2012 July 20, 2020 / Italian Content / api, avvocato del diavolo, bad ideas, development, freedom, mysql, oracle, twitter

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 il gradasso Read More »

Windows x64: 32bit Odbc vs 64bit Odbc

November 10, 2011 November 10, 2011 / English Content, Knowledgebase / database, I-hate-64-bit, oracle, visio

I run into a very big trouble on these days. My big company delivered to me a Windows7 64bit system (first error) I asked for Office 64 bit and Visio2007 32 bit I tried to connect to Oracle (second error) to reverse engenieer a DB with Visio2007 I got a “driver architecture” error under Visio2007. …

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

Shopping in the IT

January 22, 2008 January 18, 2009 / English Content, Legacy ObjectsRoot.com / ant, apple, ARC, database, db, engine, file, good, google, hard, make, microsoft, mysql, News, opinion, oracle, ping, search, search engine, Software, sql, ui, war, web, yahoo

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

July 3, 2007 January 18, 2009 / English Content, Legacy ObjectsRoot.com / build, easy, meta, oracle, postgresql, script, small, sql, table, ui, vi

Sometimes I need to build a small script to delete a huge set of tables of a schema. In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences": select 'drop table ' || table_name || ' cascade constraints;' from all_tables where owner='protoss' and table_name not like 'BIN%';select 'drop view …

oracle mass table drop Read More »