</p> ('791', '191', '扳手');
, Z) M1 S/ d r+ J p Insert into TBC_TM_CATEGORY
6 s5 z7 H! |2 q; x) B+ B (CATEGORY_ID, SUPERIOR_ID, CATEGORY_NAME). B" J. Y' U2 P
Values
% M7 U6 @+ e h( l2 `' t ('1896', '791', '活动扳手');
: Y, a$ [" O2 _& }4 J% S 希望得到的查询结果如下:7 Y+ ~5 y7 _8 F7 P! V
CATEGORY_ID, SUPERIOR_ID, CATEGORY_NAME, path- L# y6 l- l& S0 f' ], e
191 0 吊索类 工属具类别\吊索类! U7 {* j; r# K9 v. z7 r
0 0 工属具类别 工属具类别2 ?/ K3 E, m8 b1 P$ s
791 191 扳手 工属具类别\吊索类\扳手
; p3 b8 B2 k' `/ `" |, ^ 1896 791 活动扳手 工属具类别\吊索类\扳手\活动扳手
; S: S' m" ^7 X0 A# Q7 w' A$ A, H 请高人指点!如遇正解不差分!
1 }1 d. A4 n& t4 H0 y! p 数据修改1,
# t1 b. ~3 C* P3 j update TBC_TM_CATEGORY set superior_id=' ' where category_id = '0';
" @% R+ `1 o; \) f9 ^ category_id='0'对应的SUPERIOR_ID不能为'0',否则逻辑上混乱,请楼主思考一下:9 ?3 R2 U" o. P1 W3 \9 s( z
SQL语句如下:% N; j" o1 H' t* E1 @+ i( q
select
6 I d, f8 z1 t CATEGORY_ID , SUPERIOR_ID , CATEGORY_NAME,
6 Q2 ]# z L; S U1 `# a SYS_CONNECT_BY_PATH(CATEGORY_NAME,'\') path
! Z0 P1 D! t7 M x& b from TBC_TM_CATEGORY$ l& z" Z) Q6 S9 h8 O
start with superior_id=' '- P( k5 d- M( }- j' ~$ a6 V8 Z
connect by prior category_id=superior_id |