metacat/src/sqlnodesview.sql @ 133
| 1 |
column node format 9999 |
|---|---|
| 2 |
column pnode format 9999 |
| 3 |
column nind format 999 |
| 4 |
column nodetype format a10 |
| 5 |
column nodename format a15 |
| 6 |
column nodedata format a25 |
| 7 |
select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, |
| 8 |
nodename, nodedata |
| 9 |
from xml_nodes order by pnode, nind; |