Project

General

Profile

metacat / src / sqlnodesview.sql @ 3443

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;