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, 2095🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...