truncate table

[learn]

Is there an easy way to truncate 10 tables with one command instead of typing
"truncate table table_name;" 10 times?

[pando]

no, you have to build a script then run the script

like

spool truncate.sql
select 'truncate table '||table_name||';'
from user_tables
where table_name in (blah blah blah);
spool off

@truncate.sql

[sambavan]

Syntax correction:

Originally posted by pando
no, you have to build a script then run the script

like

spool truncate.sql
select 'truncate table '||table_name||';'
from user_tables
where table_name in (blah blah blah);
spool off

@truncate.sql

spool truncate.sql
select 'truncate table '||table_name||';'
from user_tables
where table_name in ( 'blah', 'blah', 'blah');
spool off

@truncate.sql


Too many blahs. BLAH

Sam

[julian]

I use a dynamic script which truncates all tables of a schema (which comes as a parameter). I would advise you to try to make such a script (and thus practice your dynamic SQL skills :-))