metacat/src/sqlnodesview.sql @ 10194
| 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; |