Tuesday, October 24, 2006

Stadiums in London

Arsenal - Highbury

Chelsea - Stamford Bridge

WestHam United - Upton Park

Tottenham Hotspur- White Hart Lane

Charlton Athletic- Valley

Lords Cricket Ground

Saturday, September 16, 2006

London Photos

London Tower Bridge
London Tower Bridge

On the top of Greenwich
On the top of Greenwich

We on the way to Greenwich after a rain
We on the way to Greenwich after a rain

On the way to Greenwich after a rain
On the way to Greenwich after a rain


Buckingham Palace
Buckingham Palace

St Pauls Cathedral
St Pauls Cathedral

Thursday, July 06, 2006

World Cup stadiums

World Cup stadiums
CountryGroundComment
UruguayEstadio CentenarioWC Final 1934
ItalyStadio PNFWC Final 1934
FranceStade ColombesWC Final 1938
BrazilMarracanaWC Final 1950
SwitzerlandWankdorf StadionWC Final 1954
SwedenRĂ¥sunda StadionWC Final 1958
ChileEstadio NacionalWC Final 1962
EnglandWembleyWC Final 1966
MexicoEstadio AztecaWC Final 1970
West GermanyOlympiastadionWC Final 1974
ArgentinaEstadio Monumental WC Final 1978
SpainSantiago BernabeuWC Final 1982
MexicoEstadio AztecaWC Final 1986
ItalyStadio OlimpicoWC Final 1990
United StatesRose BowlWC Final 1994
FranceStade de FranceWC Final 1998
JapanYokohama Internat. StadiumWC Final 2002
GermanyOlympiastadionWC Final 2006

Monday, July 03, 2006

Sybase

DECLARE @ok char(1)
select @ok = 'S'
exec s_dcap_check_batch @ok output
if @ok = 'Y'
begin
RAISERROR 20100 'hai'
end
else
begin
RAISERROR 20100 'hihjsadp'
end

Saturday, June 17, 2006

Piano Lessons

Piano
Soldier
cbgx ccbbgx ccbbngxc

Etho oru
xvc xvc xvczz cxz cxz cvbn

Tuesday, June 06, 2006

Oracle

Oracle useful PL/Sql

COLUMN colname FORMAT A50
-- *************************************************************
/*
SELECT COLUMN_NAME FROM user_tab_columns
WHERE TABLE_NAME = 'STR_REGION'
*/
BEGIN

declare
res PKG_DATA_SOURCE_MANAGER.cur_ref ;
ress varchar2(50);
nu number:=0;
tabname varchar2(10):='STR_REGION';
begin
PKG_DATA_SOURCE_MANAGER.SP_Get_ColumnList(tabname, res);
begin
loop
FETCH res into ress;
EXIT WHEN res%NOTFOUND;
DBMS_OUTPUT.PUT_LINE (nu || ': Column: ' || ress);
nu:=nu+1;
end loop;
end;
end;
END;
/
-- *************************************************************
begin
declare
cursor user_group_cursor is
SELECT COLUMN_NAME FROM user_tab_columns
WHERE TABLE_NAME = 'STR_REGION';
begin
for user_group_row in user_group_cursor
loop
DBMS_OUTPUT.PUT_LINE (': Column: ' || user_group_row.COLUMN_NAME );
end loop;
end;
end;
-- *************************************************************

Monday, March 06, 2006

About Myself

Hi,
I am Legish