多级编目树的巧妙展示  

Clever Reveal for Multilevel Catalog Tree

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

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

出　　处：《计算机与现代化》2007年第8期6-7,10,共3页Computer and Modernization

摘　　要：在实际应用中经常会有些反映层次结构的数据,它们以多级编目的形式存储在库表中,为了能够直观地展示它们的层次关系往往需要通过编程来实现。本文通过对Oracle的SQL语句的妙用,提出用一句Oracle的SQL语句实现带线层次结构展示的妙想,此法在多级编目的字典数据的选择中得到实际应用,简便实用大大提高了程序的可靠性,也为多级编目数据展示其带线层次结构提供一种新颖的方法。Data of hierarchy is often found in its application. As a form of multilevel catalog, it is stored in tables. Programming is needed to give a vivid presentation of the hierarchy. This paper is intended for a clever idea, using SQL, based on its application. The method is applied in the choice of hierarchy dictionary data. It＇ s simple and effective and could greatly improve the re- liability of programs, offering an entirely new method to display multilevel catalog with lines for the data of hierarchy.

关 键 词：SQL 多级编目 层次结构 展示 

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