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.

Logo of British Petroil

Never in my life I saw a logo more suitable for an Oil Company : a stylized flower.

Nothing more suited to those who are polluting and destroying nature (see. Gulf of Mexico disaster).

Stay Connected.

Script PERL : Totals File in a Directory

This is a simple script to show total number of Files in a directory.

Script accepts in input one argument : Directory.

$totfile = 0;

opendir(my $dh, $ARGV[0]) || die;

while(readdir $dh) {

print "$some_dir/$_\n";

$totfile++;

}

closedir $dh;

printf(" Tot Files : $totfile \n");

Stay Connected.

Italy :14.4 mln at risk of poverty

Based on a study on Global Rights 2010 of 'Associazione Società Informazione' :

In Italy 13,6 mln of workers gain under of 1300 euro per month and between these, 6,9 mln (60% women) gain under 1000 euro per month. More than 7,5 mln of pensioners gain under 1000 euro.

In 2009, 10% of occupies in under relative poverty level (Worse % in Europe with an average of 8%).

In six years, is underlined in the study, between 2002 and 2008, net family income has lost 1,599 euros each year among workers and 1,681 between employees.

Take your consideration of these data.

Stay Connected.

Evolution of the Italian race

Something wrong happened.

Stay Connected.

Stat command in Perl (Unix/Linux)

This perl script execute a stat of a file in UNIX/LINUX environment and accept in input file name with absolute path. It shows various file info and atime, mtime and ctime.

#!/usr/bin/perl -w

#

# stat.pl

#

($dev, $ino, $mode, $nlink, $uid, $gid, $rdev, $size,

$atime, $mtime, $ctime, $blksize, $blocks) = stat($ARGV[0]);

print("dev = $dev\n");

print("ino = $ino\n");

print("mode = $mode\n");

print("nlink = $nlink\n");

print("uid = $uid\n");

print("gid = $gid\n");

print("rdev = $rdev\n");

print("size = $size\n");

print("atime = $atime\n");

print("mtime = $mtime\n");

print("ctime = $ctime\n");

print("blksize = $blksize\n");

print("blocks = $blocks\n");

($sec, $min, $hr, $day, $month, $year, $day_Of_Week, $julianDate, $dst) = localtime($ctime);

$year = $year + 1900;

$month = $month + 1;

printf(" ctime $year/$month/$day $hr:$min:$sec\n");

($sec, $min, $hr, $day, $month, $year, $day_Of_Week, $julianDate, $dst) = localtime($mtime);

$year = $year + 1900;

$month = $month + 1;

printf(" mtime $year/$month/$day $hr:$min:$sec\n");

($sec, $min, $hr, $day, $month, $year, $day_Of_Week, $julianDate, $dst) = localtime($atime);

$year = $year + 1900;

$month = $month + 1;

printf(" atime $year/$month/$day $hr:$min:$sec\n");

Stay connected.

CUBE and ROLLUP options in GROUP BY

For my actual project i am studying CUBE and ROLLUP option in GROUP BY.

These options are present from Oracle 8i and are very interesting :

ROLLUP

Rollup enables a SELECT statement to calculate multiple levels of subtotals across a specified group of dimension. Really is an extension of GROUP BY clause.

In this example are summarized totals and sales for Departments and Job Title with each totals for Department.

CUBE

Cube enables a SELECT statement to calculate subtotals for all possible combinations of a group of dimension.

In this example are summarized totals and sales for Departments and Job Title with each totals for Department and also for each job title.

Stay connected.

What wants Telefonica really ?

This interesting article "Scenarios - Telefonica's options in Brazil" speaks about an offer refused by Portugal Telecom to buy out its stake in Vivo.

Actually Telefonica controls Telecom Italia by Telco, an italian company formed also by italian banks and assurances.

Due to this participation, Telecom Italia will sell his participation in Telecom Argentina for antitrust problem while Brazilian antitrust (In Brazil, Telefonica participates Vivo with Portugal Telecom and Tim Brazil with Telecom Italia) approve it.

Now, why Telefonica want acquire total control of Vivo ? Sure it knows that if it happens, sure Brazilian antitrust encountered a monopolistic situation in mobile market and Telecom Italia will be in trouble. So what game is playing Telefonica?

The article made the following assumptions for Telefonica:

1 - RAISE ITS BID FOR THE VIVO STAKE
2 - OFFER ANOTHER ASSET IN EXCHANGE FOR VIVO STAKE
3 - BUY PORTUGAL TELECOM OUTRIGHT
4 - PURSUE TIM BRASIL

After an analysis for me behind interest in VIVO really there is interest in eliminate TIM BRASIL from Brazilian Telecom Market or directly acquire total control of Telecom Italia.

The battle has just begun.

Stay Connected.

What exactly is cloud computing?

In linkedin i have encountered this question : "What exactly is cloud computing?".

Really what is the meaning of "cloud computing"?

For me best answer is this :

"Cloud computing is internet-based computing, whereby shared resources, software and information are provided to computers and other devices on-demand, like the electricity grid"

This sentence is extracted from "Wikipedia" at this link.

Example of electricity grid is best form to understand what really is "Cloud Computing" for everyone both IT experts and not.

As always wikipedia is to be best tool to learn more about something.

To Next Post.

Primer Mundo (First World)

With this term, some south American Countries indicate Europe , Usa or countries with a better Life Level. But when I see in my Country Italy : political Corruption Level, racism, unemployment,…. I have some dudes about what is really First World.
I live in a Country famous in the world for his food, his beautiful historical monuments and women, and for oldest criminal association called Mafia and now also for his extravagant First Minister Berlusconi.
Last one is a typical Italian Man: crafty, profiteer and Latin lover, but more is owner of Banks, Televisions, newspapers, insurance company, …. In a very democratic and advanced country, that I have in my mind this not possible.
Italy is a racist country and this is demonstrates by growing intolerance cases, and for a great emigration country like Italy it’s not acceptable.
More actually is in a strong cultural decline with strong federalist currents and I don’t see a good future for my country.
So somebody can say me what are differences between Italy and so called Second World or Third World Countries ? because I just can’t see any difference.
To the next Post.

Perl : Programming Documentation Site

For some scripts in my work on HP Unix Pa-Risc/Itanium I’m using PERL.
It’s a very good scripting language and I have found this site to help me in script creation:

Site : http://perldoc.perl.org/index-functions.html

I recommend this site, it’s a very good resource and help for Perl programming.

To the next Post.

JGraph : beautiful choice

For a java swing management tool for my current Interconnection project I needed a java library to show a graphical representation of an internal algorithm.
So I started looking for java libraries for the simple graphical representation and found these libraries:

• Piccolo2D : http://www.piccolo2d.org/index.html
• JGraph : http://www.jgraph.com/

Really I needed a simple library to draw: links, rectangles and rhombus, common flow-chart symbols.

Best of these for my needs is JGraph , very complete and simple with a complete documentation. Respects a Piccolo2D is very complete in the linking management and layout design.

Very big problems for me were redistributing shapes and redesign all the forms and links, avoiding intersections.

In JGraph you can adopt, once created all shapes and links, a layout that redesign all shapes apply a particular representation (Tree, circular, organic, …) or you can implement generic Interface mxGraphLayout to create your own layout.

I used JGraph 6 for swing application and really recommend it.

To the next Post.

Italy vs Italy

Italy is a great country. It’s my country. It has a great history, beautiful cities, good food, beautiful women and very bad managers, I think worst in Europe and probably in the entire world.

Really there are two classes of people: honest, working and capable on one side and thieves, profiteers and incapable on the other side.
You said “This happen everywhere!!!”. It’s true, but in Italy, second class of people is Managers, Political and generally it command on the other class.

In Italy there are few cases where good and capable people in positions of responsibility, generally are people : friend of …, sons of …, nieces of … or members of powerful organizations (legal or not).

This explains the dire situation of Italian Companies (for example Telecom Italia).

This class is greedy for money and power as well as incapable and this obviously affects capable class.

In conclusion options for capable class are only three: Change to upper class, leave the country or remain.

First option it’s possible only associated some powerful organizations or serve someone.
I recommend second option more dignified and honorable.

To next post.

Italian IT : history of a chronic patient

In this post I want analyze or try to analyze, actual state of IT in Italy.
This theme is recurrent in my posts, simply because I am living a very difficult period in IT work area in my Company and in general in my country.

I know that possible cause is the global crisis, I know that Greece is at border of default, I know that Italy is better positioning than other European countries (ndr: Is it true this ?), but I am very worried about future. Why we are arrived at this point?

I worked from 1993 in IT and in these years in this sector many events have happened year after year and IT lost his importance and role.

I know it’s a global trend, as I wrote in a previous post.

But why IT is always seen as a cost to cut? First cost to cut.
I think simply because Italian management doesn’t know IT importance.
This is due essentially at three factors:

- Italy really is an old country with an average age very high then with an ancient Management.
- In Italy don’t exists a correct Technical Carrier in IT, generally a new employees graduate enter as a system analyst without having developed a single line of code, therefore haven’t knowledge of the entire IT production cycle.
- Companies not invest in training courses, fundamental in a continually evolving sector.

Another important factor to consider is the application of organizational methodologies predominantly Anglo-Saxon (Most IT companies are from USA) without changes or adjustments at reality very different both culturally and historical.
So a methodology that is successful in USA many times is a disaster in Italy or don’t reach expected results.

Current Trend of Italian Technological Company is to outsource IT Area ( I am witness of this in Telecom Italia S.p.A.) to few big IT consulting player (Accenture, Engeener, …) managing entire IT production Cycle.

This choice for a telecommunications company where IT systems strongly support core business meaning be easily blackmailed by these companies and I doubt that there are budget savings in long term (real reason of this outsourcing operation).
Moreover many times these consulting companies to economize use graduates without experience with obvious problems in implementation and service quality.

In conclusion, the situation is serious and I don’t see a short-term solution for IT in Italy, I hope that necessary measures are taken before this chronic patient dies.

To the next post.

IT in Italy

According to the report Assinform, the computer industry in 2009 decreased by 8,1%, while telecommunications recede by 2.3%.

The long wave of crisis strikes even on the shores of Information and Communication Technology.

And Italy is no exception: the first report data Assinform edited by NetConsulting pleasantries without describing the state sector in the peninsula: the ITC shall register an overall negative trend of 4.2% in 2009.
The report informs us that last year the business of the ICT market in Italy was 62 million euros.

Doubtful even software & services (-5.6%) and technical assistance (-5%). Among the programs there is no category showing no minus sign: application to -4.1%, -2% middleware, system software falling by 4.6%.
The crisis services, however, threatens several highly qualified professional, as evidenced by the numbers for the training (-8.8%) and consulting (7%).

I am a witness to the crisis, my company is cutting 2,150 professionals in the name of a false restructuring, moving into a smaller company that at best will have 3 years of life.

IT is always understood as an expense by management not as a benefit or a sector that benefits a company.

For this reason, cuts are made, badget are reduced to limit the cost, but for a Technology Company as Telecom Italia S.p.A. this will mean to go into Business failure.

To the next post.

Chrome Stop-Motion Animation

A very beautiful video about Chrome.

Never cease to amaze me the Google Creativity.

To the next post.

Leaving Italy

This morning i read a newsletter from a blog "Italiansinfuga"

In this blog there are many articles about experiences of Italians in other countries and practical advice for those who want to move to other countries.

In 4 months that i read this blog, i never read a bad experience, specially about young Italians that leave Italy after graduation, because not encounter a work.

A phrase that strikes me about all in daily post is "Italy is a country for old men", there aren't spaces for young people.

It's very sad read this, but is more sad know it is true.

But it's true, in Italy a young don't have opportunities specially after a graduation.
Scientific Research in Italy don't exist.
I have friends, very intelligent, graduates, capable but jobless or with temporary jobs underpaid.

Only way to encounter a work is if you know someone with a little recommendation regardless of ability.

So Given this situation the only solution is simply : Leave Italy, certainly is the advice that I will to my son when it's time.

To the next post.

Chrome or not Chrome ?

I state that i am a Google's big fan but Chrome is in my opinion the best browser actually. After years of Internet Explorer 5,6,7 and 8, a couple of years with Firefox, finally i discover Chrome.
First Release was a disaster, i download it but when i couldn't navigate on my gmail site. Incredible a Google browser than not permitted go on his sites !!!!! Really a big disappointment.
After a month approximatively i downloaded a more stable version, a very simple and light browser without many function but that worked fine, i was happy!
In that period i used both Chrome and Internet Explorer.
But real leap forward in my opinion was done with version 4 by introducing extensions bridging that gap that divided him from Firefox primarily.
Actually there are many extensions in https://chrome.google.com/extensions and a big developers community.

But why switching to Chrome? Simply because is light and intuitive.
Light and Intuitive, two main features that must have a browser. More is perfectly integrated with another google instruments (gmail, feed, note, buzz, ...). So my advice is to download and use it.

Actually Chrome is third Browser more used but i bet that in three years will be second or first.

In Wikipedia you find a very complete explanation and history of this beautiful browser http://en.wikipedia.org/wiki/Google_Chrome

Bye to the next post.

My First Post

With this post, today, 01/April/2010 17.58, start my blog officially.
There're many things to say but write in another language is always difficult, and my English level not is so good.
Actually i am at office, bored and doing a work that not so good. I work in a big Italian Telecommunication Company
and this isn't his best period, really Italian IT are many years that is in problem.
I want speak about technical solutions, about me, about Telecommunication Sector, about my country, about all attract my attention, i will use English, Spanish and Italian for my posts.

Happy reading, hoping that my grammar errors will not come too horrified.