Posts

Showing posts from 2011

Linux over the last 20 years

Linux has come a long way in the last 20 years. Surprisingly Linux usage at home seems to be shrinking, but growing in the enterprise. I think 5 years back the only serious alternative to Windows at home was Linux. But with the popularity of Apples iMac and Macbook, the usage of Linux is declining at home. See the following infographic on how Linux and the Internet  has changed over the last 20 years

Math Graphing Startup

A Math Graphing Startup, that should help with big data analysis. http://techcrunch.com/2011/06/24/desmos-graphing-calculator/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+Techcrunch+%28TechCrunch%29

Creating Oracle table with XMLTYPE column

If you create a table with an XMLTYPE column create table test (name varchar2(60), xml_col xmltype) ; You get the following error message Error starting at line 22 in command: create table test (name varchar2(60), xml_col xmltype)  Error at Command Line:22 Column:0 Error report: SQL Error: ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "TBS_3" To work around this problem all you need to do is define the Column storage for the XMLTYPE column to b a clob. SQL> create table test (name varchar2(60), xml_col xmltype not null) xmltype column xml_col store as clob SQL> insert into test values ('abc', xmltype(' World ')); SQL> select name, extractvalue(xml_col, '/hello') value from test3 Name        Value ----------------- Hello       World