Hi Ravi,

This article on the net posted by Levent Camlibel on July 20, 2003 at
the following URl will be of help

http://www.vbdotnetheaven.com/UploadFile/lcamlibel/DataTransferfromSQL04
082005084827AM/DataTransferfromSQL.aspx

Thanks


Victor


-----Original Message-----
From: ravi.v
[mailto:oracledba-ezmlmshield-x85574052.[Email address protected]
Sent: Saturday, January 05, 2008 4:27 PM
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