Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE my_table1
    ("RID" int, "ID" int, "VALUE1" int)
;

INSERT ALL 
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1001, 1)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1002, NULL)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1003, NULL)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1004, 1)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1005, NULL)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132501, 1006, 1)
    INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132502, 1006, 1)
        INTO my_table1 ("RID", "ID", "VALUE1")
         VALUES (132502, 1007, 1)     
SELECT * FROM dual
;
8 rows affected

CREATE TABLE my_table2
    ("RID_2" int, "ID_TBL_2" int, "NEW_BOOL_COL" int)
;

INSERT ALL 
    INTO my_table2 ("RID_2", "ID_TBL_2", "NEW_BOOL_COL")
         VALUES (132501, 3214, NULL)
    INTO my_table2 ("RID_2", "ID_TBL_2", "NEW_BOOL_COL")
         VALUES (132502, 3215, NULL)     
SELECT * FROM dual
;
2 rows affected

update my_table2 t2 set NEW_BOOL_COL = 
( select 
  case when count( case when value1 = 1 then 1 end ) = 
    count(*) then 1 else 0 end 
from my_table1 t1 where t1.rid = t2.rid_2 
group by t1.rid
);
2 rows affected

select * from my_table2;


RID_2
ID_TBL_2
NEW_BOOL_COL


132501
3214
0

132502
3215
1