Update query if statement for Oracle
You could use CASE expression in the SET
clause.
For example,
UPDATE tableSET schema.column = CASE WHEN CO= 'Y' AND COM='Y' THEN 'Y' ELSE 'N' END