XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES?
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Victor TischukSubject: XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES?
Author: Victor Tischuk
Date: 04 Dec 2006 09:16 PM
Hi.

Is it possible to use xquery & xmltable to generate a column of all nodes and another column of just those nodes with a particular name or value?

Thanks,

Victor
Postnext
Ivan PedruzziSubject: XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES?
Author: Ivan Pedruzzi
Date: 04 Dec 2006 10:24 PM

Hi Victor,

Could you please post a concrete example of what you are trying to do?

Ivan Pedruzzi
Stylus Studio Team
Postnext
Victor TischukSubject: 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.

Thanks,

Victor
Postnext
Ivan PedruzziSubject: XMLTABLE WITH COLUMN OF ALL NODES AND COLUMN OF CERTAIN NODES?
Author: Ivan Pedruzzi
Date: 05 Dec 2006 11:13 AM

Which database are you querying?

How the XML structure looks like?


Ivan Pedruzzi
Stylus Studio Team
Posttop
Victor TischukSubject: 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.

Thanks,

Victor
 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.