adminschool.net wiki

전체테이블 TRUNCATE하는 쿼리 만들기

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