Oracle | Gioorgi

oracle mass table drop

Jul 3, 2007 · 1 min read · build easy meta 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.
In Oracle is easy to do it, using the meta tables "all_tables", …

Read More
Shopping in the IT

Jan 21, 2008 · 2 min read · 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 ·
Share on:

Oracle buys BEA and Sun buys MySql.
In reply,Migrosoft is hungry and is watching Yahoo :-)
<joking>
Any bets on the next money-based-news?
I'm going …

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

Nov 10, 2011 · 1 min read · database oracle visio ·
Share on:
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 …
Read More
Twitter il gradasso

Aug 25, 2012 · 2 min read · api avvocato-del-diavolo development freedom mysql oracle twitter ·
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 …
Read More
Oracle Invalid number ORA-01722

Jul 15, 2013 · 1 min read · 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 …

Read More
Debian perfect work environment

Sep 28, 2014 · 3 min read · ibm linux oracle unix virtual-box 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 …
Read More
ORA-01461: can bind a LONG value only for insert into a LONG column

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

[caption id="attachment_5294" align="alignright" width="150"] Disapprove with me![/caption]

Okey, you know Oracle. A very good …

Read More
Oracle Database Sync

Nov 22, 2016 · 1 min read · oracle synchronization 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.

I will show here a very fast …

Read More
Oracle Auto increment trigger HOWTO

Dec 13, 2016 · 1 min read · 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 …

Read More
Oracle SQL Developer Keep Alive plugin

Jan 26, 2017 · 1 min read · oracle plugin sql ·
Share on:

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 …

Read More
- 1
- 2