oracle 对某列连续的数据为一组，如何写SQL

Answer 1

select wm_concat(t.a) from table1 t
where t.b='123456'