To run Oracle SQLcl in batches

I wrote the following batch file to output table data to CSV file using Oracle SQLcl in Windows environment, but it doesn't work except to access the database.
Please teach me how to write correctly.

@echo off
echo set sqlformat csv^
echo set heading off feedback off^
echo spool c:\PIYO.csv^
echo select* from PIYO^
echo spool off | C:\sqlcl\bin\sql-Luser/password@//172.16.xx.xxx:1521/HOGE.FUGA

Interactive execution of the following results in a CSV file output:

cd C:\sqlcl\bin
sql user/password@//172.16.xx.xxx:1521/HOGE.FUGA
SQL>set sqlformat csv
SQL>set heading off feedback off
SQL>spool c:\PIYO.csv
SQL>select* from PIYO;
SQL>spool off

I wrote a batch file referring to the solution of my Stack Overflow.

sql oracle

2022-09-30 19:31

1 Answers

^& is missing compared to our solution.

@echo off
echo set sqlformat csv^&^
echo set heading off feedback off^&^
echo spool c:\PIYO.csv^&^
echo select* from PIYO^&^
echo spool off | C:\sqlcl\bin\sql-Luser/password@//172.16.xx.xxx:1521/HOGE.FUGA

2022-09-30 19:31

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656