Project

General

Profile

metacat / src / sqlnodesview.sql @ 8556

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;