truncate table in oracle code example
Example 1: truncate oracle
TRUNCATE TABLE tablename
Example 2: oracle sql truncate table
-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;
TRUNCATE TABLE tablename
-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;