-----------------------------------------------------------
--        name quikdriv.sql
--     version 0.0
-- description A quick driver for SQL statements.
--    synopsis No arguments.
--       usage SQL> quikdriv
--    comments Hack the 'select' statement as necessary.
--    creation 21 Jul 2008
--   copyright David Clement (2008). Use it if you like it.
--    warranty None expressed or implied.
--      author David Clement
--     changes
----------------------------------------------------------

begin
    for i in (select 'truncate table' || tname
        as cmd
        from tab)
    loop
        execute immediate i.cmd;
    end loop;
end;