Revision 150
Added by Matt Jones almost 24 years ago
| sqlnodesview.sql | ||
|---|---|---|
| 3 | 3 |
column nind format 999 |
| 4 | 4 |
column nodetype format a10 |
| 5 | 5 |
column nodename format a15 |
| 6 |
column nodedata format a25 |
|
| 6 |
column nodedata format a23 |
|
| 7 |
column docid format 999 |
|
| 8 |
column rnode format 9999 |
|
| 7 | 9 |
select nodeid node, parentnodeid pnode, nodeindex nind, nodetype, |
| 8 |
nodename, nodedata
|
|
| 10 |
nodename, nodedata, docid, rootnodeid rnode
|
|
| 9 | 11 |
from xml_nodes order by pnode, nind; |
Also available in: Unified diff
rewrote DBSimpleQuery and associated classes to no longer use Oracle's hierarchichal query syntax -- now this should work with any JDBC compliant backend DB