(manub22) In my previous XML related posts I wrote about how can we query and SELECT XML strings & pull data from parent-child nodes and hierarchies. In this post we’ll see how we can modify that XML data by applying DMLs to it.
Other News
Meaningful XML
(Dave Cassel) Another day, another code review. Today I came across a function that generates non-meaningful XML. This is something that at first glance feels like it has a nice structure to it, but there’s a better way. First, let take a look at the XML (I’ve changed the XML and the code to make it
On the quest of explaining Semantic Web
(Adrian Gschwend) A few weeks ago I did the (for me) so far most successful presentation about semantic web. And guess what: it worked so well because I almost did not mention it in the presentation.
Writing Excel Spreadsheets files from within the Oracle database using Java and PL/SQL
(Simon Greener) My EXPORTER package + Java code has functions called WriteExcelSpreadsheet that can be used to create and export any SQL SELECT statement to disk as an Excel Spreadsheet using Oracle database’s DBMS_JOB or DBMS_SCHEDULER.
The Dangers of Implementing Recurring Background Tasks In ASP.NET
(Phil Haack) I like to live life on the wild side. No, I don’t base jump off of buildings or invest in speculative tranches made up of junk stock derivatives. What I do is attempt to run recurring background tasks within an ASP.NET application.
Optimize your Tablespaces and Bufferpools-3: Bufferpool Optimization
(samkumar) It has rather been quite a busy quarter for me… Office has kept me quite busy and was quite pre-occupied with my job… But here I am back with all the stuffs I wanted to share…
Obtaining Results from Parallel Tasks
The tenth part of the Parallel Programming in .NET tutorial examines the generic Task class. This is a subclass of the Task class seen previously that permits a result to be generated and accessed from the calling thread.
Working With Functions in FSharp
(Alok Pandey) A function is a sub program, it groups code into a single unit and reduces the complexity of large code. It provides a modular approach in the programming language.
Disabling Oracle Streams Propagation when nothing else works
(Miladin Modrakovic) It’s been a while since I wrote a post .. Here is very short tip how to disable Oracle Streams propagation when nothing else is working..
A Fast Way to Get Started with Websphere MQ for DB2 Active-Active Databases
(Cecile Madsen) A few months ago, IBM made two-site Q Replication available in DB2 Advanced ESE and InfoSphere Warehouse at no additional cost. The main reason was to give DB2 a built-in solution for active-active databases. Since a lot of DB2 people are new to Q Replication, I will show you how eas