CODEWITHSUNDEEP
sqloracle-databasesqlplus
Jordan Bagwell
Jordan Bagwell

Reputation: 13

How to close the window after a sql file has finished running

I have a script that I turned into an exe that connects to an oracle database, then runs a sql script. after the script is done, the window stays open. I have tried a few commands and the sql> stays there. Thanks!

ALTER USER &user_name ACCOUNT UNLOCK;

Upvotes: 0

Views: 883

Answers (1)

Sentinel
Sentinel

Reputation: 6449

Edit your C:\Scripts\Script2.sql file and add an exit statement at the end on a line by itself.

You may need to ensure that the prior command is correctly terminated with a ; or a / character on a line by itself.

ALTER USER &user_name ACCOUNT UNLOCK;
exit

Upvotes: 1

Related Questions