How to truncate all user tables?

Question

How can I truncate all user table in oracle? I have problem with tables constraints.

Answer 1

No need for variables

begin
  for r in (select table_name from user_tables) loop
    execute immediate 'truncate table ' || r.table_name;
  end loop;
end;

Regards K

Answer 2

See my answer to this SO question.