insert into xlzx_nrwh
(NRZJ,
CDZID,
BT,
NR,
FBSJ,
FBR,
SFZD,
FBZT,
SYXSTP,
SYTPLX,
SSBM,
GCDZJ,
CJR,
CJSJ,
XGR,
XGSJ,
YDCS,
URL,
FJ)
SELECT floor(dbms_random.value(0,100))||NRZJ,
CDZID,
BT,
NR,
FBSJ,
FBR,
SFZD,
FBZT,
SYXSTP,
SYTPLX,
SSBM,
8,
CJR,
CJSJ,
XGR,
XGSJ,
YDCS,
URL,
FJ
FROM xlzx_nrwh WHERE gcdzj = 7
floor(dbms_random.value(0,100)) 随机生成0到100之间的数据,并且四舍五入取值