New Year

This 2011 starts with changes and news :

• Home's Change
• New Argentinean's Projects

In this new year I would like to achieve the following objectives:

• Improve my English Level
• Improve my Chess Level
• Improve my incomes
• Be a better Christian
• Learn at least two new programming languages

I hope to achieve at least half of these objectives.

Stay Tuned.

UPDATE TABLE A FROM TABLE B IN ORACLE

Hi all

A little big problem, i always forget in oracle how to do an update on a table from data on another table, so i fix it in my blog :

update table1

set field = (

select field

from table2

where table2.id = table1.id

);

Stay tuned.

SP-552 oracle bind variable not declared

Hi all,

About this error we have lost many time. I hope this post can help someone.
My script sql is :


set verify off

set heading off

set linesize 400

spool RIL_388_OP_INS_AnagD4

COLUMN indGruppoiInG NEW_VALUE indGruppoiInG

SELECT max(substr(nome_elemento_associazione,4,4))+1 indGruppoiInG FROM SCTELEM_ASSOC WHERE TIPO_ASSOCIAZIONE = 'GRUPPI_IN' AND NOME_ELEMENTO_ASSOCIAZIONE LIK
E 'GIG%';

SELECT '@INFO AGGIUNTO GRUPPO IN ' || 'GIG' || lpad(to_char(&indGruppoiInG),4,'0') || ' IN CATEGORIA LA UNDELIVERED SERV >' || 'CATG0010' || '<' from dual; COLUMN indGruppoiInG NEW_VALUE indGruppoiInG SELECT max(substr(nome_elemento_associazione,4,4))+1 indGruppoiInG FROM SCTELEM_ASSOC WHERE TIPO_ASSOCIAZIONE = 'GRUPPI_IN' AND NOME_ELEMENTO_ASSOCIAZIONE LIK E 'GIG%'; SELECT '@INFO AGGIUNTO GRUPPO IN ' || 'GIG' || lpad(to_char(&indGruppoiInG),4,'0') || ' IN CATEGORIA LA UNDELIVERED SERV >' || 'CATG0010' || '<' from dual;

spool off

When we have executed this script alone it was OK. But when it was executed after another script, was showed this error :

SP-552 oracle bind variable "indGruppoiInG" not declared

After many controls we have discovered that a previously script seated "set define #", this command (see this link causes previously error.
Solution for this error was put at beginning my script sql, this command :

set define on

To avoid previously different define setting.

Stay tuned.

Summer is ending !!!!

Summer 2010 is ending !

Only another week of this hot August and all starting again.

Real work is starting again.

Stay connected.

What to say ?

There really is not much to say, looking at my country, watching politicians, looking at my company, looking to the future.
Better watch the World Cup and think about your next vacation.

Stay Connected

Telecom Italia's Fate

Telecom Italy yesterday saw its shares traded at less than 0.9 euros. Given symbolically devastating as the controlling shareholder (Telco) paid to Tronchetti Provera (the previous shareholder) a figure well over two euros per share.
But not 'the only problem for Telecom Italy.
In addition to the debt of almost 35 billion euros, the corporate structure is complex and is intertwined with the strategies of the member 'industrial' Telco, Spanish Telefonica.
So check Telco Telecom Italy, Telefonica controls Telco.
Both Telefonica, Telecom and Italy have substantial investments in South America. Telecom are the last remaining overseas investment.
In Argentina, the plot has caused no end of official documents.
Now is the time in Brazil, where Telecom subsidiary TIM Brasil, while Telefonica, along with a Portuguese operator, controls another mobile operator.
Telefonica now wants to 'get rid' of the Portuguese partner.
If the transaction from going through, Brazil would open antitrust problems, since two of the major mobile operators would refer to a person 'unique'.
Apart from this, one wonders: Telefonica, shareholder / competitor of Telecom Italy, that interest will solve the problems of Telecom?
Behind these industrial and financial scenarios, there are Italian users who are compelled to have the reference operator (Telecom 'ensure' universal service) an ailing companies, leveraged and further immobilized by the current corporate structure.
Stay connected.

A sad future

On Metro, an International free newspaper, an article appeared today:

"In 2030 Italy poorer and older."

In that article many statistics supported that idea.
Only 20 years from now, not so much time left.

I actually think that Italy will be poorer in just 5 or 10 years, because today nobody is taking the necessary care to the economical and political situation to avoid this.

I already spoke in another post about Technological and Scientific state in Italy, explaining that new generations must go to other countries to work.

My company is the best example of a big company destroyed by Italian greed and lack of future vision; in only 13 years, since privatization they have destroyed a great heritage of one of the most important Telecommunication Company in the world.

Stay connected.