Wednesday, January 31, 2007

sqlplus - Termout

Termout is one of those sqlplus settings which tend to cause confusion. It only applies to output from running script files.

abc.sql:
set termout off
select 'abc' from dual

and run it like this in sqlplus:
@abc.sql


and no output is generated in the terminal. But this does'nt work for scripts which contain anonymous pl\sql blocks etc.

No comments: