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