I am having some trouble with the SQLPlus tool over the command line.
Here is what I do:
on the command line I give the command:
sqlplus /nolog @c:\mycommands.sql
The mycommands.sql file contains:
CONNECT sys/syspass@mydatabase as sysdba
Select * from some_table
However, the command line only shows the message connected and does not exit. The spool file also contains no information. I want it to execute the command and quit SQLPlus.
I hope someone can help me.