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!

 

Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-16, 233👍, 0💬