Hi All,
i have a requirement where there is a need to update a column to NULL, depending upon a column existing into one another table and that query to check the existence is below:
select count(*) from DMU_CT18_ACCT_DSTR where acct_alt_id in (select acct_alt_id from seods01.dstr_alt_id where length(acct_alt_id)=27);--62765794
There is a column called EODS_DSTR_ID which needs to be updated in the DMU_CT18_ACCT_DSTR table, please suggest the best way to do this updation on more than 62 millions records.