摘要: 1、递归查询 Orcale 10g: select level, m.pid,m.nodename,m.nodemark nodemark,m.parentid,m.nodeurl,m.classname from (select distinct m.pid pid,m.nodename nodename,m.nodemark nodemark,m.parentid parentid,m.nodeurl nodeurl, m.classname classname,ordernum from bs_t_sm_menutree m, bs_t_sm_rol... 阅读全文
posted @ 2012-07-06 15:25 shouma 阅读(209) 评论(0) 推荐(0) 编辑