Oracle SQL statement to update column values based on specific condition
this one helps. I have a table which is having 3 columns-PID,LOCID,ISMGR.
Now in existing scenario, for some person, based on the location ID, he is
set as ISMGR=true. But as per the new requirement, we have to make all the
ISMGR=true for any person
Date : November 22 2020, 11:00 PM , By : Alexander Ling