ID可以随机生成,数据太多的时候有可能会重复 19位
to_number(to_char(systimestamp,'yyyy') || trunc(dbms_random.value(100000000000000,999999999999999)));
具体执行插入sql 如下
INSERT INTO user_item (
ID, name, code,create_userid,create_time,update_userid,update_time,is_deleted,tenant
)
select
to_number(to_char(systimestamp,'yyyy') || trunc(dbms_random.value(100000000000000,999999999999999))),
name,code,create_userid,create_time,update_userid,update_time,is_deleted,999999
from user_item where tenant is null ;