Monthly Archives: October 2012

Borrow Build Abandon / Jamie McGregor Smith, 2012

Now that London 2012 is in full swing, I think more or less everyone has agreed that we’ve built some bloody beautiful buildings for the Games. What will prove to be the real test though, in terms of ‘successful’ architecture, is what happens in the years to come.

The planners and architects for London 2012 were determined that we wouldn’t be saddled with useless buildings for years, so many structures will come down completely, whereas others, like the main stadium and aquatic centre, will be ‘deconstructed’ into smaller versions.

Greece, however, did not plan so well. Photographer Jamie McGregor Smith has been documenting the mess that resulted from the Athens games in 2004. Only 3 of the 22 purpose-built structures remain in use, the others costing $100 million a year in upkeep costs. Ouch!

An exhibition of Jamie’s photographs opens in September.

View original post

Advertisements

Fashion & Style Guru

What would it be like to drift through the inside of a kaleidoscope? With the brilliant fabrics and interiors from the Missoni Casa, you have the answer.  

View original post 339 more words

Guenadi N Jilevski's Oracle BLOG

Listing active contexts in Oracle

— Listing active contexts
CREATE OR REPLACE PROCEDURE listContext AS
list DBMS_SESSION.APPCTXTABTYP;
cnt NUMBER;
BEGIN
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_territory = ‘||SYS_CONTEXT(‘userenv’,’nls_territory’));
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_currency = ‘||SYS_CONTEXT(‘userenv’,’nls_currency’));
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_calendar = ‘||SYS_CONTEXT(‘userenv’,’nls_calendar’));
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_date_format = ‘||SYS_CONTEXT(‘userenv’,’nls_date_format’));
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_date_language = ‘||SYS_CONTEXT(‘userenv’,’nls_date_language’));
DBMS_OUTPUT.PUT_LINE(‘USERENV nls_sort = ‘||SYS_CONTEXT(‘userenv’,’nls_sort’));
DBMS_OUTPUT.PUT_LINE(‘USERENV session_user = ‘||SYS_CONTEXT(‘userenv’,’session_user’));
DBMS_OUTPUT.PUT_LINE(‘USERENV current_user = ‘||SYS_CONTEXT(‘userenv’,’current_user’));
DBMS_OUTPUT.PUT_LINE(‘USERENV current_schema = ‘||SYS_CONTEXT(‘userenv’,’current_schema’));
DBMS_OUTPUT.PUT_LINE(‘USERENV current_schemaid = ‘||SYS_CONTEXT(‘userenv’,’current_schemaid’));
DBMS_OUTPUT.PUT_LINE(‘USERENV session_userid = ‘||SYS_CONTEXT(‘userenv’,’session_userid’));
DBMS_OUTPUT.PUT_LINE(‘USERENV currend_userid = ‘||SYS_CONTEXT(‘userenv’,’current_userid’));
— Listing user defined namespaces
DBMS_SESSION.LIST_CONTEXT(list, cnt);
FOR i IN 1..cnt LOOP
DBMS_OUTPUT.PUT_LINE(list(i).namespace||’  ‘||list(i).attribute||’ = ‘||list(i).value);
END LOOP;
END;
/

View original post

Life, Photography & Other Mistakes - is now dormant

A private garden, The Garden of Cosmic Speculation, is inspired by science and mathematics with sculptures and landscaping on themes such as black holes and fractals, created by Charles Jencks at Portrack House, near Dumfries in South West Scotland. Only open one day each year, it raises money for Maggie’s Centre, a cancer care charity.

View original post