Subject:XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES? Author:Victor Tischuk Date:05 Dec 2006 09:59 AM
Hi,
I'de like to list all descendants in one column and the second column would flag the ones that have no children, and a third column with a flag for the nodes that have an element with a particular name.
Subject:XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES? Author:Victor Tischuk Date:05 Dec 2006 12:10 PM
Hi,
I am using Oracle, no structure yet for this idea, but I want to list all nodes in the first column, and use other columns in the same row to flag the node as atomic, has a certain value, etc, then use SQL to select from the xmltable.