HEY RAVI,
Use the "spool" command in SQLPLUS and save the output to a ".txt"
file. Then import the ".txt" file into EXCEL.

SELECT *
FROM (SELECT rownum row_num, A.empno, A.ename,
A.job, A.mgr, A.hiredate, A.sal, A.comm, A.deptno
FROM (SELECT *
FROM emp
) A
) B
WHERE B.row_num between 1 and 50000
/


SELECT *
FROM (SELECT rownum row_num, A.empno, A.ename,
A.job, A.mgr, A.hiredate, A.sal, A.comm, A.deptno
FROM (SELECT *
FROM emp
) A
) B
WHERE B.row_num between 50001 and 100000
/


Have a great Weekend!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: ravi.v
[mailto:oracledba-ezmlmshield-x85574052.[Email address protected]
Sent: Saturday, January 05, 2008 10:27 AM
To: LazyDBA Discussion
Subject: Pushing Data into excel sheet !!!!

Hi Experts,



Can somebody help me in pushing the output of a SELECT statement into
excel
sheet.

Also if the table is too huge (2 million rows) how to select the data
from
the table in splits for example: first 50,000 rows and next 50,000 rows
and
so on.



Help in this regard would be highly appreciated.



Kind Regards,

Ravi.







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page