CODEWITHSUNDEEP
oracle11gsqlplusspool
joec
joec

Reputation: 3543

Stop spool printing the sql query used (Oracle)

I have this running in SQLplus 

set feedback off
set pagesize 0
spool TypeDrop.sql
select distinct 'drop type '||object_name|| ';' from user_objects where object_type='TYPE';
spool off

It prints out to TypeDrop.sql:

SQL> select distinct 'drop type '||object_name||';' from user_objects where object_type='TYPE';
drop type ADDRESS_OBJTYP; 
drop type PERSON_OBJTYP;                                                                                                                                              
SQL> spool off

How do i get it to just output the drop statements? thanks

Upvotes: 3

Views: 48556

Answers (3)

Paolo
Paolo

Reputation: 101

Use sqlplus -s. The -s flag means silent

Upvotes: 10

rahul
rahul

Reputation: 17

try

set echo off

Upvotes: -1

akf
akf

Reputation: 39485

Running from within a script, set termout off works. It doesnt if you are just typing into the terminal.

create myScript.sql:

set feedback off
set pagesize 0
set termout off
spool TypeDrop.sql
select distinct 'drop type '||object_name|| ';' from user_objects where object_type='TYPE';
spool off

and from your sqlplus prompt:

SQL> @myScript

will do the trick.

Upvotes: 5

Related Questions