Database Query Is not working in batch file

Question

@echo off

set user_name=username
set password=
set sid=sid

@echo select distinct scid, to_char(dlog_on_timestamp,'dd-Mon-YYYY hh:mi:ss') from table where dlog_on_timestamp > sysdate-7; | sqlplus -s %user_name%/%password%@%sid% >> C:\Users\test.txt

While running this batch file, > symbol created file sysdate-7. But I need to run the DB query and the result should be stored in test.txt

Corion · Accepted Answer · 2018-10-15 16:56:15Z

1

Put quotes for your shell (cmd.exe ?) around the command:

@echo "select distinct scid, to_char(dlog_on_timestamp,'dd-Mon-YYYY hh:mi:ss') from table where dlog_on_timestamp > sysdate-7;" | sqlplus -s %user_name%/%password%@%sid% >> C:\Users\test.txt

answered Oct 15, 2018 at 16:56

Corion

3,9151 gold badge20 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Database Query Is not working in batch file

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related