Load data from query to excel file in a procedure
857372Jun 15 2011 — edited Jun 16 2011Hi everybody,
Can anyone help me to load data from a query to excel file ?
This has to be done in a procedure, but not in manual method.
I will tell you my requirement with an example query of emp and dept table.
select e.ename,e.sal,d.dname
from emp e, dept d
where e.deptno=d.deptno;
The result of this query has to load in an excel file.
Thanks in advance.