参考:http://www.cnblogs.com/walk-the-Line/p/4882866.html
使用Kettle资源库数据表操作:
select ml
from (select sys_connect_by_path(t.directory_name, '/') ml
from R_DIRECTORY t
start with t.id_directory_parent = 0
connect by prior t.id_directory = t.id_directory_parent)
order by ml
结果附图: