父子结点树转化为多级编码探讨与研究  

The study and discussion of translating the father-child node tree into the multilevel code

作　　者：刘星沙[1] 夏明伟[1] 

机构地区：[1]中南大学现代教育技术中心,湖南长沙410075

出　　处：《企业技术开发》2007年第8期6-7,共2页Technological Development of Enterprise

摘　　要：在实际应用中存在很多反映目录结构的数据以父子结点的形式存储,并需要将其上下层关系转换成编码中的多级编码形式。文章灵活应用Oracle的SQL语句,用一句SQL语句实现了该编码转换。文章提出的一句SQL语句简便、实用,极大提高了程序初始化的速度与可靠性,也为其它树型关系数据进行编码转换提供了新方法。In practice, there are many data of directory construction stored as father-child nodes, and recod-ing from the father-child node to multilevel code is needed. In this paper, we realize the coding transition using only one SQL sentence by applying the Oracle＇s SQL sentence neatly. The only one SQL sentence is simple and practical, which greatly improves the speed and reliability of the programs initialization and of-fers a new method for coding transition of other tree-shaped relation data.

关 键 词：SQL 父子结点 树 多级编码 转换 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]