Search
Translate / Traduci
-
Available even in U.S.A. Support Gioorgi Editorial Board
June 2023 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Gioorgi EverGreen
Tag Archives: oracle
Smart Sync
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 … Continue reading
Posted in English Content, Gio's Software Projects
Tagged database, mssqlserver, oracle, sqlite
Comments Off on Smart Sync
Semplice metodo per storicizzare i dati su database
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, è … Continue reading
Posted in Italian Content, Structured Query Language (SQL)
Tagged database, oracle
Comments Off on Semplice metodo per storicizzare i dati su database
SQLite Oracle Compatibility Layer
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
Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL)
Tagged oracle, sql, sqlite
Comments Off on SQLite Oracle Compatibility Layer
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 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 dup, duplicate, duplicates, evil, oracle, postgresql, removal, sql
Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite
Italian Accent Oracle fix
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 oracle, relax
Comments Off on Italian Accent Oracle fix
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 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 oracle, plugin, sql, sqldeveloper
Comments Off on Oracle SQL Developer Keep Alive plugin
Oracle Auto increment trigger HOWTO
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 auto, datamodeler, increment, oracle, tip
Comments Off on Oracle Auto increment trigger HOWTO