DROP and TRUNCATE in ORACLE | Difference between DROP and TRUNCATE in oracle | ORACLE
In Oracle, both DROP and TRUNCATE are used to remove data from tables, but they serve different purposes and have distinct effects.
1. DROP
Purpose:
The DROP command is used to completely remove a database object, such as a table, index, view, or user, from the database.
2. TRUNCATE
Purpose:
The TRUNCATE command is used to remove all rows from a table while preserving the table structure for future use.
Both commands are auto-committed and cannot be rolled back once executed.