请教ORACLE如何创建单表合计的视图

请问ORACLE怎么创建单表合计的视图
我有这样一个表
ID           NAME                 NUM
1                 AA                     5
2                 AA                     6
3                BB                     8
4                BB                     7
5                CC                    9
6                CC                    9
怎么创建一个视图可以将同一个NAME的NUM进行合计,
视图结果如下
ID             NAME                 NUM 
1                  AA                     11
2                  BB                    15
3                 CC                    18
------解决思路----------------------

引用:

select rownum id,t1.* from (select name,sum(num),to_char(wmsys.wm_concat(remarks)) from t group by name) t1 order by t1.name;

------解决思路----------------------

SELECT ROW_NUMBER()OVER(ORDER BY RN) ID,NAME,NUM,REMARK

FROM(

select MIN(ID) RN,NAME,sum(num) NUM,to_char(wmsys.wm_concat(REMARK)) REMARK

from T

GROUP BY NAME)