Your Daily Dose of English

Today I want to recommend a good English course in internet :

"Your Daily Dose of English".

To the next Post.

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.