摘要: SQL:select id,pid,treename,url,treetype from web_menu_tree where roleid = 1 and delflag = 1 start with id = 1 connect by prior id = pid表结构-- Create tablecreate table WEB_MENU_TREE( ID NUMBER not null, PID NUMBER, TREENAME VARCHAR2(200), URL VARCHAR2(200), ROLEID ... 阅读全文
posted @ 2011-12-02 11:03 暗夜螃蟹 阅读(205) 评论(0) 推荐(0)