SQL & PL/SQL

Table A

DEPT || NAME
============
1 || DEF
1 || ABC
2 || ABC
3 || DEF


TABLE B

DEPT || NAME || FLAG
=================
1 || ABC || 0
23 || ABC || 0



I'm supposed to update the Table B Flag to 1... Matching the distinct values of DEPT and NAME from Table A
The Column 'Flag' in table B default value is 0