Update a Flag Only If All Matching Conditions Fail Using Oracle SQL

Looping Through a JSON Array in PL/SQL 12.1: Alternatives to JSON_TABLE Function