Posts tagged XQuery Update
New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 184.108.40.206.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT for short, W3C standard/draft 2011), this is one of the big new features in Oracle 12c. With this update XQuery functionality, the XQuery standard is further expanded in a mature query language for XML (/unstructured) information.
Now also in Oracle 12c, this has immediate consequences for following, implementing a XQuery standard across the board. The following features, functions have now been given the status “deprecated” (most of them introduced in Oracle version 10.2) for updating XML data:
All Oracle SQL functions for updating XML data are deprecated. Oracle recommends that you use XQuery Update instead. These are the deprecated XML updating functions:
updateXML insertChildXML insertChildXMLbefore insertChildXMLafter insertXMLbefore insertXMLafter appendChildXML deleteXML
Although being signaled “deprecated”, be aware that they are still supported, but Oracle move to a position that the new XQuery Update functionality will be the basis for further More >
Just finished my Birds of a Feather XMLDB panel session in the Marriott Hotel and now looking back on a event full day. It all started of with a Keynote session with among others Mark Hurd. the most interesting bit, in my honest opinion, was the announcement of more details in Oracle 12c. I will come back later on this, as far as I am allowed being a beta participant, but hereby some shots from the Keynote session that will give you a pretty good idea on usefulness of pluggable databases in Oracle 12c.XMLDB News
So with all this excitement going on about 12c, are there already some small details about new XMLDB functionality. Via a Tom Kyte presentation, Hands-on Labs and some other sessions, the following details were made available to the public. Keen on XMLDB stuff, this is what I picked up.
- XMLDB is now an integrate, mandatory part of the database
- XQuery Update facility, already available in 220.127.116.11, is now a fully supported standards in 12c and onwards
- XQuery Full Text search, is now available, in Oracle 12c
- XMLType CLOB based storage will be deprecated in Oracle 12c
As with all Oracle 12c related things at this time, Oracle will have the last word if it also More >
I just made use of the very cool OTN Virtual Developer Day Database site. In this environment you can follow OTN Developer Day sessions, for example, at home, while making use of all the material available on that site plus the downloadable Virtualbox OTN Developer Day Appliance. Despite you can choose for tracks like Java, .Net, APEX, there is also a database section which handles (as you might expect it from me regarding interest) Oracle XMLDB functionality.
There is a 1 hour webcast available from Mark Drake, Oracle Product Manager, that takes you along all the basics / general overview (basic due too it is too extensive to show it in only an hour) of possibilities of Oracle XMLDB functionality. For convenience there is also a PDF document that has most of the slide info of the webcast. It doesn’t contain the demo’s or extra Virtualbox OTN Developer Day Appliance first steps info, of course, and what to do to reset the training XMLDB environment in this appliance.
This PDF and the webcast starts with the Oracle safeguard (legal disclaimer), with the general product outline slide saying among others that Oracle is not responsible or obliged to actually build-in features More >