bat file command for Write exact plsql query output into csv file

Question

I want to execute query from batch file and put exact output of query into csv file. Like: my query is : select sysdate from dual. Output of this :

Sysdate
23-feb-2013

So, in csv it stored as

sysdate
22-feb-2013

DB: Oracle 11g OS: windows 7

Kindly plz help me to achieve this ..

Donato Szilagyi · Accepted Answer · 2013-02-23 16:39:56Z

2

c:\myfolder\mybatch.bat:

call sqlplus oracleuser/oraclepwd@oracledb @c:\myfolder\myquery.sql

c:\myfolder\myquery.sql:

set head off
set feed off
set pagesize 0
spool c:\myfolder\myresult.csv
prompt sysdate
select to_char(sysdate, 'dd-mon-yyyy') from dual;
spool off
set head on
set feed 6
quit

edited Feb 23, 2013 at 16:39

answered Feb 23, 2013 at 13:11

Donato Szilagyi

4,3654 gold badges40 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

bat file command for Write exact plsql query output into csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related