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