2017年4月25日
【转】oracle CONNECT BY PRIOR叶子节点查找根节点
摘要： SELECT TRANS_ID FROM TRANS_INST WHERE connect_by_isleaf=1 START WITH TRANS_ID =480242 CONNECT BY PRIOR UP_TRANS_ID = TRANS_ID; 说明： 表TRANS_INST(TRANS_I 阅读全文
posted @ 2017-04-25 08:43 dirgo 阅读(1840) 评论(0) 推荐(0) 编辑