利用rowid完成自连接的表更新

开发人员反馈有一条业务SQL很难实现，具体要实现如下功能：

表数据如下图，用name字段去更新fl字段，得到结果如右图所示：

   =======>   

DROP TABLE TEST_W;
create table test_W (ID NUMBER,NAME CHAR(1),FL CHAR(1));
INSERT INTO test_W VALUES(1,'A','');
INSERT INTO test_W VALUES(1,'B','');
INSERT INTO test_W VALUES(1,'C','');
INSERT INTO test_W VALUES(1,'D','');
INSERT INTO test_W VALUES(2,'E','');
INSERT INTO test_W VALUES(2,'F','');
INSERT INTO test_W VALUES(2,'G','');
INSERT INTO test_W VALUES(2,'H','');
INS