SELECT * FROM ALVEARC.TABLE_UADOW
ALTER TABLE ALVEARC.TABLE_UADOW MODIFY CUENTA VARCHAR2(100);
UPDATE MD_SITE_USER SET IS_DISABLED='Y' WHERE USER_OR_GROUP='U'
MERGE into EDMADMIN.MD_SITE_USER t1
using (SELECT * FROM ALVEARC.TABLE_UADOW) t2
on (UPPER(t1.USER_NAME)=UPPER(t2.CUENTA))
when matched then
update set t1.is_disabled='N'
where t1.user_or_group='U'
No hay comentarios.:
Publicar un comentario