How to view Google Events from Oracle DB

Oracle has put a lot of effort to integrate a lot of XML functionality into the database, must people don't use just because they don't know is there.

Here is a pretty cool way to integrate with Google Calendar, basically using the XML functions in the DB you can see a RSS feed as if it were a table, you'll need to create a google calendar and make it public, you can also use this method to integrate other information into the DB and then publish it in your portal or application, I just sticked this select into a Portal dynamic page and put it as a portlet.

select
extractValue(value(t),'/entry/title/text()','xmlns="http://www.w3.org/2005/Atom"') as title, extractValue(value(t),'/entry/summary/text()','xmlns="http://www.w3.org/2005/Atom"') as summary
from
TABLE(xmlsequence( extract( httpuritype('http://www.google.com/calendar/feeds/juan.alberto.becerra@gmail.com/public/basic').getXML(),'/feed/entry', 'xmlns="http://www.w3.org/2005/Atom"'))) t