Use the TRUNCATE statement to remove all rows from a table. TRUNCATE cannot be rolled back. This is faster than doing a DELETE as no logging is involved. For more details, see the topic DELETE in this guide.
TRUNCATE TABLE emps;
You cannot truncate a view, stream or foreign table.