Collections:
SQL*Plus Commands Stored in a File in Oracle
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle?
✍: FYIcenter.com
If you have a group of commands that you need to run them repeatedly every day, you can save those commands in a file (called SQL script file), and using the "@fileName" command to run them in SQL*Plus. If you want to try this, create a file called \temp\input.sql with:
SELECT 'Welcome to' FROM DUAL; SELECT 'FYIcenter.com!' FROM DUAL;
Then run the "@" command in SQL*Plus as:
SQL> connect HR/retneciyf SQL> @\temp\input.sql 'WELCOMETO ---------- Welcome to 'FYICENTER.COM -------------- FYIcenter.com!
⇒ Use SQL*Plus Built-in Timer in Oracle
⇐ Revise and Rerun the Last SQL Command in Oracle
2020-06-08, 5780🔥, 0💬
Popular Posts:
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundati...
How To Get Help Information from the Server in MySQL? While you are at the "mysql>" prompt, y...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...