还有问我怎样使用SQL语句对其数据库DATA进行分层分组使其显示出来的数据为
A---1---X
| |-Y
| |-Z
|
|-2---L
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
B---1---X
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
|
|-4---X
| |-Y
| |-N
X---2---L
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
|
|-5---L
| |-M
| |-N
的结构
A---1---X
| |-Y
| |-Z
|
|-2---L
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
B---1---X
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
|
|-4---X
| |-Y
| |-N
X---2---L
| |-Y
| |-Z
|
|-3---L
| |-M
| |-Z
|
|-5---L
| |-M
| |-N
的结构
select up,down,level from DATA connect by prior up=down 如果有开始位置就加上start with 条件
详细的看一看树开形查询的详细文档!
http://community.csdn.net/Expert/topic/3448/3448087.xml?temp=.5652887里标准bom的计算