Project

General

Profile

metacat / src / sqlnodesview.sql @ 150

1 124 jones
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 150 jones
column nodedata format a23
7
column docid format 999
8
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;