Archive for July, 2007

better unix life2

Jul 31st

Posted by Giovanni Giorgi in English Content

If you need to work on cluster, is nice to have syncronized terminals to send the same commands in parallel.

Is it also doungerous, so do some test before sending a bunch of vi commands!

On Unix, a cheap and fast solution is Kde “konsole” which has such option.

Look under “View/Send input to all Sessions” menu and try it out.  I was happpy with version 1.6.6 of konsole. I am not a fan of “xterm variants”, but konsole looks great.

,

Storie vere!

Jul 7th

Posted by Giovanni Giorgi in English Content

In onore della laurea di una mia cara amica, ripubblico e segnalo una serie di "storie universitarie", che sono sicuro strapperanno più di un sorriso. Buona lettura!

oracle mass table drop

Jul 3rd

Posted by Giovanni Giorgi in English Content

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 ' || view_name || ' ;'    from all_views where owner='zerg' ;    select  'drop sequence ' || sequence_name || ' ;'    from all_sequences where sequence_owner='spacemarine' ;

The "BIN%" table are special temp tables of oracle.

On PostgreSQL, try use PG_TABLES meta-table

Happy sqlizing!

More >