I've got an SQL statement or a series of statements that I want to run more than once. Is there a way to put them in a file and then run them from inside sqlplus?
From the OS command prompt, navigate to the directory where the filename.sql file is stored.
Log into SQLPlus from the command line as the oracle user you wish to execute the statement.
The statements in the file will be run as if they had been typed in at the prompt directly.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe
Thanks for your feedback. Let us know if you have additional comments below. (requires login)
This will clear the history and restart the chat.