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) )
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) )