oracle #mssql #migration #multi-table-column (1) 썸네일형 리스트형 [MSSQL] oracle multi table column update to sql server -- base oracle UPDATE ( select cu.stat as stat , cs.sys_date as last_update_date , cu.user_id as user_id , cu.sys_date as update_date from table_1 cs , table_2 cu where cs.emp_sabun = cu.user_id ) SET STAT = 'N' , update_date = to_char(sysdate, 'yyyymmdd') where user_id IN ( select distinct expired_user from table_a where trunc(expired_date) = trunc(sysdate) and SYSTEM_NAME IN ('xxxxxx','yyyyyy'.. 이전 1 다음
