Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load data from query to excel file in a procedure

857372Jun 15 2011 — edited Jun 16 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2011
Added on Jun 15 2011
26 comments
906 views