Oct 28 2008
I was just informed that Carl Backstrom died in a car accident during the weekend. Carl was a driving force and evangelist especially for APEX. I only met him (physically) once, during Oracle Open World 2008, during Mark Drake’s presentation were he helped out and I had the honor to shake hands. He had the …
Oct 22 2008
Tom Kyte will give a 2 day seminar, with the possibility to ask him about his new presentation material. He will be presenting in the Oracle Dutch HQ, de Meern, Holland on the 26th and 27th of Januari 2009. He will be presenting the following topics: Related posts: OOW2K6 – and Mr. Kyte has left the building… Graham …
Oct 21 2008
During a mind exercise with some of my OTN XMLDB forum peers, I discovered (tkprof…), that the non-recursive statement used for, for example the following: SQL> xquery 2 let $auction := ora:VIEW("XTAB") RETURN 3 FOR $b IN $auction/site/people/person[@id = "person0"] 4 RETURN $b/name/text() 5 / is internally rewritten to SQL> SELECT COLUMN_VALUE RESULT_PLUS_XQUERY FROM XMLTABLE …
Oct 19 2008
I found a very cool presentation. Yep it is about XML, The concepts behind XQuery to be particular, but it is easy relating to it with a (Oracle) relational mindset. Its about choosing the right storage (which doesn’t have to physical), about the language, which index will or won’t suffice your needs, access paths, compression, and …
Oct 18 2008
Driven by a post from Lewis about “OSDM: Rerverse Engineer A Schema“, I dared my luck to play with Oracle SQL Developer Data Modeler (OSDM), trying to see if it understands the XML database realm off doing things. It doesn’t understands it…at least, yet. I used the early adopter release 1.5.1 (build 518). I wonder …
Oct 16 2008
Nowadays, this “Collection Iterator Pickler Fetch” output in an explain plan is less and less seen as the XML database functionality becomes more and more stronger in re-writing statements. Alas, I got one, again. SQL> xquery 2 let $auction := ora:VIEW("XM_TAB") RETURN 3 COUNT( 4 FOR $i IN $auction/site/closed_auctions/closed_auction 5 WHERE $i/price/text() >= 40 6 …
Oct 09 2008
I missed out on a lot of cool, informative or funny web posts due to severe jet-lag this time. The following is for prosperity (and I hope I will still make up for the posts about Oracle Open World this year I didn’t do…yet). Info about this shot: Photography: Someone who was kind enough to …
Oct 09 2008
We Dutchies are in luck. Mr. Thomas Kyte will be in Holland on the 3th of November presenting “11 Things about 11g” on the Logica premises during a Logica Guru4Pro event in Amstelveen. Besides this presentation, there will be the opportunity to askTom the questions you always wanted to ask him. You will be welcome from 14:30, …
Oct 05 2008
A few days ago we had an AMIS Query Report dealing with the items we thought were useful to pass on regarding Oracle Open World this year. The database issue were split in presentations from Gerwin Hendriksen and me. My session dealt with Grid 2.0, XMLDB, Building a APEX content management system while using XMLDB …
Oct 05 2008
I liked the slide share presentation Lucas had made for the the AMIS Query session so I will give it a try. For my session on Sunday, have a look here: Related posts: My Oracle Open World 2008 XMLDB Sessions AMIS Query – Preview Session Oracle Open World 2008 OOW 2008 Content Catalog has been …
Recent Comments