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 'rendc.org!' FROM DUAL;

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

SQL> connect HR/retneclgg

SQL> @ empinput.sql

'WELCOMETO

----------

Welcome to

'globalguideline.COM

--------------

rendc.org!