Delete vs Truncate vs Drop :Oracle Interview Questions - Part 3

preview_player
Показать описание
Delete, Truncate and Drop all can be used to remove the contents of a table but they have significant differences and unique properties.
While Delete is a DML statement, truncate and DROP are DDL.
Delete can be used to remove partial/Selective data. While truncate removes the entire content of the table.
#OracleInterviewQuestions #DeletevsTruncate #TechCoach
Рекомендации по теме
Комментарии
Автор

Hi bro very nice explation bro..its very clear bro..thyank you for sharing your knowledge bro..keep share bro..

devanaidu
Автор

Hi sir, what about that watermark concept ....please upload a video for that also
...

abhilashgaddam
Автор

Please make a video on subquery, correlated query

deepakranjan
Автор

Can we rollback the data after delete and commit ?

nandhinirajan
Автор

How to reset the high watermark? I got this question twice now

AnweshDash