Marian,
> 1.
> SELECT
> xpath_nodeset(xml_data, '/mydocument/body/chapter/contents/paragraph[@objid
> = "02"]|/mydocument/body/paragraph[@objid="87"]')
> FROM xmltable
> WHERE id = 3
You could maybe use the xpath: '//paragraph[@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.