shutdown and startup

[Innila]

Hi,

Since the definition alone is not very much clear, let me explain with an example in detail.
As already given, Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.

Let me create a sql file named samplescript.sql since termout works for sql scripts.
The samplescript.sql consists of a simple query,
select empno, ename from emp;

Now, let me run the script by setting termout as on
Note :- Default value for termout is "on"


SQL> set termout on
SQL> @samplescript;

EMPNO EMPNAME
------------ -----------------
25398 STEVE

1 row selected.

This is the output of the script file, check out for the output while running the same sql file with termout "off"

SQL> set termout off
SQL> @samplescript;
SQL>


The output is not displayed or lets say, the output is suppressed since the setting of termout is off.
If there is a requirement where u want to run a sql script but avoid the output, then u can go for termout off.

Hope it is clear now.