TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(1000000000000000000, 10000000000000000000)))
例如:
update test set mid = TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(1000000000000000000, 10000000000000000000))) where ID = '14272930341068800'
TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(1000000000000000000, 10000000000000000000)))
例如:
update test set mid = TO_CHAR(FLOOR(DBMS_RANDOM.VALUE(1000000000000000000, 10000000000000000000))) where ID = '14272930341068800'