I worked with Oracle for this project, and sometime i need to truncate and clean all my oracle database’s content. So instead of truncate the tables one by one, i found a simple query to generate a simple truncate query.
select 'truncate table ' || table_name || ';' from user_tables
Hope it helped others 🙂