select t.a, t.b, t.c, t.d, regexp_substr(t.d, '[^、]+', 1, level, 'i') e
  from RDMODS.T_TEST_BANK t
connect by level <= regexp_count(t.d, '[^、]+')
       and rowid = prior rowid
       and prior dbms_random.value is not null;

• Oracle