建立一個塊
SQL>DECLARE
SQL>BEGIN
SQL>DELETE FROM TABLE1;
SQL>DELETE FROM TABLE2;
SQL>DELETE FROM TABLE3;
.......................
SQL>END;
SQL>DECLARE
SQL>BEGIN
SQL>DELETE FROM TABLE1;
SQL>DELETE FROM TABLE2;
SQL>DELETE FROM TABLE3;
.......................
SQL>END;
truncate table TABLE2;
truncate table TABLE3;
truncate table TABLE4;写完保存位test.sql
sql>@test.sql即可