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.
Watch video DROP and TRUNCATE in ORACLE | Difference between DROP and TRUNCATE in oracle | ORACLE online without registration, duration hours minute second in high quality. This video was added by user VCODE LOGIC 25 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 38 once and liked it 2 people.