Hi , everybody...

I want somebody to write for me the general format in PL/SQL using EXECUTE IMMEDIATE clause with a group by...

For example if a routine accepts all the components of a typical SQL clause (with aggregation , column) dynamically , how can I write this clause....
How for instance , could we write the
'select count(ename),deptno from emp where deptno=10 group by deptno ' using the execute immediate?

Thanks...
Simon