Oracle XMLDB XQuery Update in Database Release 18.104.22.168.0
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 mentioned in that release or in that form…etc…so in that context it looks like…
The next release of Oracle 22.214.171.124.0 will contain the XQuery Update facility. With this in place, the XQuery language build-in the Oracle Database version since database version 10.2.0.1.0, will now come to its full extend supporting the whole range from not only SELECT functionality, but also REPLACE, UPDATE and DELETE functionality. In an SQL update statement you can make use of this by using the XQuery XMLQUERY operator to make full use of this XQuery Update Facility functionality. Of course it doesn’t have to be SQL, also the normal XQuery Oracle 11g operators can be utilized in JDBC/Java or other flavored environments or PL/SQL can now make use of this. Other means of XML interfacing would be in using the Native Database Web Service support, amongst others based on PL/SQL input, or via XQuery for Java (XQJ) means.
This also means that you now can use XQuery to its full potential, following the standard (or should I say “W3C Recommendation” – I am never sure if standard = recommendation but anyway…) and no longer have to use SQL/XML operators like updateXML(), insertChildXML() and other operators like them and go “full XQuery”.
Regarding recommendations… I really can, regarding the OTN Virtual Developer Day Database site. If you want to brush up your knowledge or start a new topic, this is really a good way to start. I know there are also OTN Developer Day sessions you can actually visit somewhere in your “neighborhood” or otherwise during the Hands-on Labs of the upcomingÂ Oracle Open World in San Francisco.
- Oracle announces XQuilla / XQilla XQuery engine available under the open source Apache 2.0 license
- Oracle Database 10g Release 2 – SQL and PL/SQL Features
- Running XQuery from Java applications using the XQJ API and the Oracle XDK implementation
- Wat kan je als Forms of database ontwikkelaar met Oracle Database Release 11g?
- Part of the Puzzle: Oracle XMLDB NFS Functionality
This entry was posted by Marco Gralike on September 22, 2011 at 11:28 am, and is filed under AMIS, Database, General, IT Architecture, Oracle, Oracle Development Tools, XML. Follow any responses to this post through RSS 2.0.You can skip to the end and leave a response. Pinging is currently not allowed.
- Enriching XMLType data using relational data – XQuery and fn:collection in action
- Oracle Database 12c: XMLIndex Support for Hash Partitioning
- Oracle Database 12c: XQuery Full Text
- Oracle Database 12c: XQuery Update
- Oracle Database 12c: Oracle XMLDB is now Mandatory!
- Hotsos 2013 – Presentation material “Creating Structure in Unstructured Data”
- Hotsos 2013 – From Unstructured to Structured…
- Basisregistraties Adressen en Gebouwen – Het importeren van Kadaster BAG data in een Oracle Database
- Kom kennismaken met AMIS en doe mee met uitdagende projecten
- OOW 2012 – And was there news on the XMLDB front…?