Oracle SQL*Plus – Interactive Mode on Windows

oraclesqlpluswindows

How can I issue commands through SQL*Plus on Windows?

In Linux is like this:

sqlplus -s /nolog<<EOF
conn username/password@database
EXECUTE some_proc;
EXIT;
EOF

And Windows?

Best Answer

That is a matter of Windows/batch, it is not specific to SQL*Plus.

You can do this:

(echo connect bp/bp@192.168.1.71/min19_o71
echo select * from dual;
echo exit
) | sqlplus -S /nolog

Result:

C:\Users\balaz>(echo connect bp/bp@192.168.1.71/min19_o71
More? echo select * from dual;
More? echo exit
More? ) | sqlplus -S /nolog

D
-
X


C:\Users\balaz>

Or just use a script, that method is specific to SQL*Plus:

C:\Users\balaz>type script.sql
connect bp/bp@192.168.1.71/min19_o71
select * from dual;
exit

C:\Users\balaz>sqlplus -S /nolog @script.sql

D
-
X


C:\Users\balaz>
Related Question