I have an Oracle instance, with several schemas (all starting with the same prefix).
PATT_A PATT_B PATT_C ...
All of them have the same table, and I'd like to update all of them in one shot (with SYSTEM account).
I know I can get these schemas doing so :
SELECT username FROM dba_users WHERE username LIKE 'PATT_%' ;
And I would like to apply the same query on them, like this one :
UPDATE table1 SET field1 = 'new_value' WHERE field2 = 'filter' ;
I assume something like a loop could do the job, but I don't know how to use it here.