CREATE TABLE TRUNC_TEST(N1 NUMBER, N2 NUMBER, N3 NUMBER);
INSERT INTO TRUNC_TEST VALUES(1,2,3);
INSERT INTO TRUNC_TEST VALUES(5,4,6);
INSERT INTO TRUNC_TEST VALUES(6,7,8);
SELECT *FROM TRUNC_TEST;
TRUNCATE TABLE TRUNC_TEST;
SELECT *FROM TRUNC_TEST;