Question Oracle 10g

Bonjour
j'aimerai savoir si oracle 10g supporte des procedures PL/SQL comportant des requetes avec Group By Cube ou Group By Rollup!!

Oui.

Code:

---

1 2 3 4 5 6 7 8 9 10

Begin For crs In (select deptno, count(*) from emp group by rollup(deptno) ) Loop Null; End Loop; End;

---

merci