Hello Guys,
Today we will see two DML(Data Manipulation Language) Commands Delete and Truncate,
Then we will Conclude the Difference between two,
So Lets See......
Conclusion:
Hence we can Conclude that with Delete command we can delete specific record using where clause,
We can also delete all the records using Delete command without using where clause,
And on the other hand we can not use where clause with Truncate command,
By default Truncate command deletes all the records from the table.
Thank you for Watching.
Subscribe my channel for more videos.
Watch video How to Implement and Differentiate Delete and Truncate (DML) Commands in Oracle 10g. online without registration, duration hours minute second in high quality. This video was added by user Hardik Parmar 16 April 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 98 once and liked it 4 people.