ORACLE批量更新GUID

UPDATE TABLENAME
SET "ID" = LOWER (
    SUBSTR (SYS_GUID(), 1, 8) || '-' || SUBSTR (SYS_GUID(), 9, 4) || '-' || SUBSTR (SYS_GUID(), 13, 4) || '-' || SUBSTR (SYS_GUID(), 17, 4) || '-' || SUBSTR (SYS_GUID(), 20, 12)
)

 

posted @ 2020-03-26 16:29  乱扔果皮  阅读(532)  评论(0)    收藏  举报