Marian,
> 1.
> SELECT
> xpath_nodeset(xml_data, '/mydocument/body/chapter/contents/paragraph[(at)objid
> = "02"]|/mydocument/body/paragraph[(at)objid="87"]')
> FROM xmltable
> WHERE id = 3
You could maybe use the xpath: '//paragraph[(at)objid = "02"]' if you want
all paragraphs at all document levels.
A nice xslt reference is:
file:///home/cnagy/offline/XSLTreference/Output/index.html
There you can also exercise your xpath skills...
Cheers,
Csaba.