Home » RDBMS Server » Server Utilities » how could I export in excel (Client Machine) from sql query
icon8.gif  how could I export in excel (Client Machine) from sql query [message #244260] Tue, 12 June 2007 03:29 Go to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

Hi All,
I need to do a batch export to excel files form my queries into client machine.
For example:
I have three query:
1. select * from employees;

2. select * from departments;

3. select * from emp_dept_vw;


Now I want to export each query result in excel (batch Job) into client machine where only sqlplus is present.
excel file name should contain table_name.xls.
I am currently using oracle 8i.
Is there any solution for that?
I am looking for the experts opinion.

Thanks in advance for the help.

Regards
Sanka
Re: how could I export in excel (Client Machine) from sql query [message #244263 is a reply to message #244260] Tue, 12 June 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Click on the Search button, put "excel" in the search field, click on the Search button and read the topics.

Regards
Michel
Re: how could I export in excel (Client Machine) from sql query [message #244265 is a reply to message #244263] Tue, 12 June 2007 03:41 Go to previous message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

I've searched in the forum before I posted this.
I've not found any solution regarding this context.
Could you please guide me if you have found any solution.

Thanks

Sanka.
Previous Topic: ora-00600
Next Topic: Problem in Import
Goto Forum:
  


Current Time: Thu Dec 08 18:45:19 CST 2016

Total time taken to generate the page: 0.07424 seconds