metacat/src/sqlnodesview.sql @ 5128
1 | 124 | jones | column node format 9999 |
---|---|---|---|
2 | column pnode format 9999 |
||
3 | column nind format 999 |
||
4 | column nodetype format a10 |
||
5 | 166 | jones | column nodename format a11 |
6 | 150 | jones | column nodedata format a23 |
7 | 166 | jones | column docid format a9 |
8 | 150 | jones | column rnode format 9999 |
9 | 124 | jones | select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, |
10 | 150 | jones | nodename, nodedata, docid, rootnodeid rnode |
11 | 124 | jones | from xml_nodes order by pnode, nind; |