摘要:
注释:depid 为节点编号 upid为父节点编号 SMDEPARTMENT 表名称1、部门3及其所有下级SELECT lpad('', 2 * (LEVEL - 1), '') || t.depid AS depid ,t.* FROM SMDEPARTMENT tCONNECT BY t.upid = PRIOR t.depidSTART WITH t.depid = 32、部门3及其所有上级SELECT lpad('', 2 * (LEVEL - 1), '') || t.depid AS depid ,t.* FROM S 阅读全文