UPDATE GLDZ_640000_XMXZXXB
SET R_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)
)where R_ID IS NULL;
UPDATE GLDZ_640000_XMXZXXB
SET R_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)
)where R_ID IS NULL;