General MySQL Oracle SQL Server

SQL*Plus Commands Stored in a File in Oracle

Q

How Run SQL*Plus Commands That Are Stored in a Local File in Oracle?

✍: FYIcenter.com

A

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

⇑ Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-06-08, 5153🔥, 0💬

General MySQL Oracle SQL Server