INSERT INTO sys_role
(ROLE_ID, ROLE_NUM)
(select UUID_SHORT(), ''
from dual
where not EXISTS
(select role_num from sys_ext_role where role_num = '')
);
其他字段照旧
INSERT INTO sys_role
(ROLE_ID, ROLE_NUM)
(select UUID_SHORT(), ''
from dual
where not EXISTS
(select role_num from sys_ext_role where role_num = '')
);
其他字段照旧