SELECT a.RES
FROM RESIDENT a
where a.ACTIVE_RECORD = 1 and a.DELETED = 0

UPDATE RESIDENT SET PROPERTY_NO = UNIT_NO

UPDATE RESIDENT SET ENROLL_ID = PROPERTY_NO ||'0'|| RESIDENT_NO