【原创】SQL栏目树的代码
本文由网友whl供稿，特此感谢！
/**
* Desc: 取栏目树 ,过滤用户权限和无效栏目
* Author: WHL
* Date: 2009-05-31 15:17
*/
/** 1. 取某用户有权限（np_cms_column_security表有记录且t.action_1 = ‘1’）的栏目的树 **/
create or replace view V_NP_CTREE_BS as
select B.* from (
select A.*, lag(A.column_id) over(partition by A.column_id order by 0 ) RK
from (select /*+choose */
t.*
from np_cms_column t
where t.is_active = '1'
connect by prior t.column_id = t.parent_id
...
