现有类别表如下: create table TBC_TM_CATEGORY (
8 p& ^' B$ t8 s' t; Z6 r9 q k CATEGORY_ID NVARCHAR2(50) not null,
: d. t9 O8 M$ Y* c& `0 J SUPERIOR_ID NVARCHAR2(50) not null,
2 f# ?" W* j3 ?: d4 z2 J [/ m) ^ CATEGORY_NAME NVARCHAR2(50) not null," I, Y! j, `$ h+ @- ~7 _
constraint PK_TBC_TM_CATEGORY primary key (CATEGORY_ID)$ F9 d, V: k/ ]- @ [ B+ E8 Z6 t
)
0 O: a \: w% ~$ r6 V 数据如下:
8 u# H- Y% `1 j6 E Insert into TBC_TM_CATEGORY5 p* w! ~ [+ ]1 h% {% U+ U
(CATEGORY_ID, SUPERIOR_ID, CATEGORY_NAME), M( x! {" \- Y7 i* |; Y9 q4 P
Values
4 m0 Z0 P& O Y: M4 g3 E' | ('191', '0', '吊索类');$ v5 P$ ?0 Y" {7 F! L N1 B: m: z
Insert into TBC_TM_CATEGORY
; p& v+ ?& A, L" j (CATEGORY_ID, SUPERIOR_ID, CATEGORY_NAME)
9 u+ P4 b% \- Q8 N" r Values
4 Q, s, e: b1 f9 }0 k3 k, G* t" B ('0', '0', '工属具类别');& E" k) }1 I( C( H& U; F
Insert into TBC_TM_CATEGORY* P+ K' X% ^& p t3 v. F, p
(CATEGORY_ID, SUPERIOR_ID, CATEGORY_NAME)
# P0 x, N b8 |; P- e; E0 l& r- L3 k7 {
Values |