Look at the script below:REM remove the header of columns
SET HEADING OFF
REM remove the 'xx rows selected.' after a query
SET FEEDB OFF
REM emp title + underline
SELECT 'EMP' FROM DUAL
/
REM emp data
SELECT '---' FROM DUAL
/
SELECT ename
FROM emp
/
REM dept title + underline
SELECT 'DEPT' FROM DUAL
/
SELECT '----' FROM DUAL
/
REM dept data
SELECT dname
FROM dept
/
REM reset sql*plus environment
SET FEEDB 6
SET HEADING ON
Assuming this script is stored under c:myscriptsscript.sql, you'll get the following in SQL*Plus:SQL> @c:myscriptsscript.sql
EMP
---
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
JAMES
FORD
MILLER
DEPT
----
ACCOUNTING
RESEARCH
SALES
OPERATIONS
f
abcv
A
C
SQL>
HTH,
MHE