OraFAQ Forum: Server Utilities » how could I export in excel (Client Machine) from sql query

Home » RDBMS Server » Server Utilities » how could I export in excel (Client Machine) from sql query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how could I export in excel (Client Machine) from sql query [message #244260]

Tue, 12 June 2007 03:29

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

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	ora-00600
Next Topic:	Problem in Import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 13:42:11 CDT 2024