SQL> SELECT 'truncate table '||table_name||';' FROM user_tables
WHERE table_name NOT IN ('TEMPLATE_XML','QUESTION_XML')
ORDER BY table_name ASC;