Oracle Database Interview Question:

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

Submitted by: Administrator

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 empinput.sql with:

SELECT 'Welcome to' FROM DUAL;
SELECT 'globalguideline.com!' FROM DUAL;

Then run the "@" command in SQL*Plus as:

SQL> connect HR/retneclgg

SQL> @ empinput.sql

'WELCOMETO
----------
Welcome to

'globalguideline.COM
--------------
globalguideline.com!
Submitted by: Administrator