batch file for running Oracle Query and save the result

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
bintoca
Posts: 3
Joined: 10 Jul 2013 01:19

batch file for running Oracle Query and save the result

#1 Post by bintoca » 10 Jul 2013 01:23

Need a batch file for running Oracle Query and save the result to a file.

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: batch file for running Oracle Query and save the result

#2 Post by foxidrive » 10 Jul 2013 03:39

Provide more information to describe the situation.

bintoca
Posts: 3
Joined: 10 Jul 2013 01:19

Re: batch file for running Oracle Query and save the result

#3 Post by bintoca » 10 Jul 2013 05:16

Need to run a query in oracle.
The query is a select query.
After running the query, need to save the result to an excel file or csv file.

foxidrive
Expert
Posts: 6031
Joined: 10 Feb 2012 02:20

Re: batch file for running Oracle Query and save the result

#4 Post by foxidrive » 10 Jul 2013 06:18

Batch files are tailored to a situation - not many of them are general purpose.

I assume you can do the query. We need to know your situation - the format of the query output would be helpful.

bintoca
Posts: 3
Joined: 10 Jul 2013 01:19

Re: batch file for running Oracle Query and save the result

#5 Post by bintoca » 11 Jul 2013 01:21

Iam having a BOoks table, which concsists of three fields. title, author,ISBN


The query should be like this select title,author,ISBN from books.

The result should come in a csv format that can be opened in excel.

Squashman
Expert
Posts: 4488
Joined: 23 Dec 2011 13:59

Re: batch file for running Oracle Query and save the result

#6 Post by Squashman » 11 Jul 2013 06:47

Show us the query command you are using and the output.

Post Reply