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, 2110🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...