update CLAION_SUARY_D set IS_HH_VALUE_CDITY_ITEMS = trunc(DBMS_RANDOM.value(1,2)) where S_ID like '%93%';
update CLAION_SUARY_D set IS_HH_VALUE_CDITY_ITEMS = round(DBMS_RANDOM.value(1,2)) where S_ID like '%93%'
trunc(DBMS_RANDOM.value(10000,2000))
trunc 是直接截断取整数
round是四舍五入取整
Oracle随机整数
like是Oracle的模糊查询