11 Replies Latest reply on Mar 7, 2013 5:09 AM by Oracle Maniac

    truncating multiple tables with single query

      Hi, I have about 12 tables that contain inter-related data, i-e with foreign key relationships. Is it possible to truncate all tables at once, kind of CASCADE delete, with one query?